#Name?

[margaret]

I have a qryCash and a frmCash. I would like the default for the control
"cashdate" to use information from a table ... tblControlfile (Be aware that
this table is a single line entry that just holds information that changes on
a day to day basis). When I put the default as

![tblcontrolfile]![fairdate], I'm getting #Name? ... I've tried even
running a query to pull the information from the table and still same
message. How can I get the default for the control "cashdate" to be the
"fairdate" information in my table?

 

[Beetle]

=DLookup("fairdate", "tblcontrolfile")

 

[Dennis]

You might also need to use this syntax:

![tblcontrolfile].[fairdate]