Running two reports at once

[SchoonDog]

Hi all,

I would like to run two reports by running only the first one.

ie) Run report A and report A and report B run and open.

Thanks,

SD

 

[SchoonDog]

Also I would like to use the same parameters from Report A in Report B.

 

[ideafixer]

To accomplish this you may have to change how you approach running reports. I imagine to run a report containing a parameter you have been entering brackets [] in the criteria field. This conveniently prompts Access to ask the user for data.

Unfortunately there is not a way to feed this parameter to your query unless you change the method for capturing user input. There are a few different ways to accomplish this. I will recommend the following course of action.

Add an "on open" event to report a. This on open event will do a few things. In the on open event use an input box to capture your parameter. Once you have stored this parameter in a public variable set the Me.Recordsource equal to your SQL statement inside the on open event. String in the value of the public variable into the Me.Recordsource SQL statement.

Depending on how you want to launch the reports, you can assign an on close event to the report A to launch report B. In the on open event of report B assign the me.recordsource to by stringing the public variable into your SQL statement.

Good luck!