Text Box

  • Thread starter Thread starter anonymous
  • Start date Start date
A

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?
 
anonymous said:
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?
Click to expand...

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.
 
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.
 
anonymous said:
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.
Click to expand...

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