Dlookup for First Record In Table

  • Thread starter SharonInGeorgia
  • Start date
S

SharonInGeorgia

tblAccountInfo table has a date field (Updated) that is set with a date
default of the day that data is imported. The same date appears for all the
records in the table. I want my main form to show the last time data was
imported into the tblAccountInfo table. I currently have a subform with the
import date in it. Can I use Dlookup instead? The only fields in common is
"Updated"

frmMainForm tblAccountInfo field: Updated
 
M

Marshall Barton

SharonInGeorgia said:
tblAccountInfo table has a date field (Updated) that is set with a date
default of the day that data is imported. The same date appears for all the
records in the table. I want my main form to show the last time data was
imported into the tblAccountInfo table. I currently have a subform with the
import date in it. Can I use Dlookup instead? The only fields in common is
"Updated"

frmMainForm tblAccountInfo field: Updated
Click to expand...


If the value of the date field is the same in all the
records, it doesn't matter which record you get the value
from, so, yes, DLookup will do that.

Use a text box with the control source expression:
=DLookup("Updated", "tblAccountInfo")
 
Top