Text Box

[anonymous]

I am trying to pull a data from query into text box:
In control Source of text box I have the following:=
[qryLastFile]![Value]
(Query runs fine), but When I open the form I get error.
Why?

 

[fredg]

I am trying to pull a data from query into text box:
In control Source of text box I have the following:=
[qryLastFile]![Value]
(Query runs fine), but When I open the form I get error.
Why?

Is there only one record returned by the query?
If so,
=DLookUp("[ColumnName]","qryLastFile")

If there is more than one record returned by the query, you will need to
use criteria to determine which record is wanted.

 

[anonymous]

I am still get:#Error
=DLookUp("[FMax]","qryLastFile")
My query: select Max(filedate) as FMax from table.
Any idea why?
I am trying to display the max date.

 

[fredg]

I am still get:#Error
=DLookUp("[FMax]","qryLastFile")
My query: select Max(filedate) as FMax from table.
Any idea why?
I am trying to display the max date.

Make sure the name of this control is NOT 'FMax'.