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] & "'"),"")
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Bank Account Database Design 5
Access Updating inventory levels 0
Design of a simple sales entry database form 1
Parameter Query Form Problem 17
How do I figure out amout due from transaction file 3
change data color based on field in table 1
access updates wrong record 5
Access Property sheet data missing also syntax 0

Back
Top