Display query result in a form

T

TLocker

I have form where 2 of the fields are "Name" and "Date of transaction".
Every time I enter a 'Name' in a new record, I want a pop up, or 3rd field,
to show the last 'Date of transaction' for that 'Name'. Thanks
 
O

Ofer Cohen

Use DMax in the control source of the third field

=Nz(Dmax("[DateField]","[TableName]","[NameFieldnameInTable] = '" &
[NameFieldNameInForm] & "'"),"")
 
Top