Multiple reports using same parameter

[venk_j]

Hi,

I am developing a database which generates many reports, all of which
use the same parameter from the user. It is like a budget system,
wherin all the reports need to print the month which is given by the
user through a parameter query. The problem I am facing is that I need
to supply the month info for each report whenever it is accessed. Is it
possible to store the parameter once it is given and reuse it in all
reports??

Thanks,
J

 

[Allen Browne]

Rather than try to share a parameter between reports, it would be easier to
provide a form and have the queries for the report read the value from
there.

For example, if you have a form named "MyForm", with a text box named
"MyDate", you could put this into the Criteria row of your query under the
date field:
Forms![MyForm]![MyDate]