Text Box Control Source

R2D2

Registered User.
Local time
Today, 21:14
Joined
Jul 11, 2002
Messages
62
I am trying to set up a text box that will display a piece of data from a table. The table contains only one piece of data, a date and time when some tables were last backed up. In the text box control source field, I used the "..." button to set it to "=[tblLastRefresh]![Backup Start Time]" (tblLastRefresh is the table I'm trying to get the data from, and Backup Start Time is the only field in this table). The table only has only one row in it. For some reason, the text box gives me a "#Name?" error. Anyone know why it's doing this and how to fix it?
 
Thanks! It worked great. I'm pretty new to Access, so I didn't know about the DLookUp function.
 

Users who are viewing this thread

Back
Top Bottom