Pass parameter value between reports in a macro

[Jensen]

I have numerous reports all selected by period.

How can I run all reports from one macro and only enter the period once?

 

[flaniganmj]

You won't be able to &quot;pass&quot; a parameter value; however, create a form with and text box linked to another small table with only one field, DATE_LOOKUP lets say, make sure the form doesn't allow addtions or deletions. Use the table in your report query criteria, i.e. [DATE_INVOICE]<[DATE_LOOKUP], make sure not to join the tables. OnClose or thru a command button w/ macro have the reports run based on that one value table. The same thing can be done completly with VBA, but this way is just as good.