Automatically update labels

[HilcrRWise]

I have a large number of reports that all have the same label caption.
This label will need to be changed at certain intervals. What I wan
to do is have a label setup on a form which when the caption is change
all the relevant labels on the reports will display the same info.

I have tried using the following expression on the labels in th
reports:

=[Forms]![Menu_frm]![Date_lbl].[Caption]

but this only works when the Menu_frm is open, when it is closed th
reports display #Name?

Is there an easy way to set it up so all the reports display the sam
captions as entered on the form without the form having to be accesse
first

 

[Chris Sergent]

You could set the form to automatically open when you open
the report and if you do not have to edit it, you could
set it to hidden and then close it automatically when the
report closes or if you already know the value you can use
a dlookup formula.

Lastly, you could use a query that either prompts for
information or has the information already in it and
reference the report to it. No form needed.

Chris