Open two reports with same input

[ITbeast]

Hello,

I'm trying to set up a way for my users to be able to enter one set of inputs, and have two reports returned. Currently they would pull up on report in which they specify a date and a district. The two reports use different queries to generate them and contain different information except for date and district.

What I want to happen now is: they push a button on the switch board, it asks for a date and district only once, then two reports are brought up in print preview mode.

Is it possible for me to do this? Any suggestions are welcome!

 

[straybullet]

Create a form for input of the date and district.
Have it opened by the button on the switchboard.
On the form, have a button which opens the 2 reports - their underlying queries referring to the date and district controls on the form.
So long as the form are open, the criteria of date and district are satisfied and the reports will open properly.


Let them hate - so long as they fear... Lucius Accius