Displaying the result of a query when opening a form

[simonc1978]

OK, here's hoping someone can help me out...

I have a form called Control Panel which opens up when I open my database. I also have a query called MaxDate which return the latest date from a table called tblSessions. How can I change the form so that it displays the result of the query MaxDate every time it is opened? I'd like it as just a little text field (label?) at the bottom of the Control Panel.

Thanks!

 

[pbaldy]

Presuming the query can't be the record source of the form, you could use a DLookup:

=DLookup("FieldName", "QueryName")

I'd actually eliminate the middle man (the query) and just do

=DMax("DateField", "TableName")

 

[simonc1978]

Presuming the query can't be the record source of the form, you could use a DLookup:

=DLookup("FieldName", "QueryName")

I'd actually eliminate the middle man (the query) and just do

=DMax("DateField", "TableName")

Thanks, I used the latter option... worked perfectly.

 

[pbaldy]

Happy to help, and welcome to the site by the way.