Can this task be done with a macro

[Vegaanders]

Hi Guys!



Before I test perhaps a simple question here can put me off the project.

Is this possible to do in one macro.

I have 4 different reports populated from 4 different queries. The input parameter is the same for all four queries.

This is what I would like to do:

When I put in the parameter (month I am interested in) the macro should fire all four reports and print them out.

Is this reachable?

Regards

[ranman256]

yes, in a form put a box for the parameter
in the queries , reference the box using the full path:
select * from table where [myFld] = forms!myForm!txBox

then the macro just opens all the reports
docmd.openreport "rpt1"
docmd.openreport "rpt2"
docmd.openreport "rpt3"
docmd.openreport "rpt4"