Date on Switchboard

[DFISHER]

I would like to put on the switchboard screen ,"Latest Update" and then a date that resides and is continously updated in a query and in a report. Each time i use in the control source:
=[Reports]![Date update]![Date]
I get #error.
Help!!!

 

[Dobie]

you have not stated which report, that is too general, you could have 20 reports, enter a report name after reports

 

[DFISHER]

The name of the report is found after the ! which is date update in this case. Isn't this the proper protocol where you have to first indicate it is a report, then the name of the report than the area the info resides.

 

[David R]

You're right, that is the correct syntax, it just wasn't obvious that [Date Update] was a report.

Try referring to the underlying query/table instead of the report. I assume this is a 'version' table that just has one field.

David R