Display query result in a form

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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
 
Use DMax in the control source of the third field

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