Print several reports using only one parameter

[jk12]

Hi. I have a problem but not sure if I can do what I want to. I have 7 daily reports that are based on different queries but want to be able to print all 7 at the same time using only one command button, but I also want to be able to have all seven run using a week commencing date entered into a parameter or something similar when the print button is pressed.

Any ideas please (if this is possible).

Thanks

 

[MStef]

Hello jk12!

Try this:
In CommandButon_Click event put:

DoCmd.OpenReport "Report1",........
DoCmd.OpenReport "Report2",......
.
.
DoCmd.OpenReport "Report7"........

 

[KeithG]

You can do that, first create an unbound form with two text boxes dteStart and dteEnd (we will name the form frmSample). Then create a command button on the form to print your seven reports. After that you have to modify the parameters of all seven queries behind the reports to this

between Forms![frmSample]![dteStart] and Forms![frmSample]![dteEnd]

Now your queries will pull the value for the parameters out of the two text boxes on frmSample