DFISHER
02-01-2002, 06:50 AM
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
02-01-2002, 07:49 AM
you have not stated which report, that is too general, you could have 20 reports, enter a report name after reports
DFISHER
02-01-2002, 08:52 AM
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
02-01-2002, 09:39 AM
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