Report/ Sub Reports and parameter queries

[jmackdaddy]

I have a master report, which contains 10 sub reports. Each of the sub reports is based on parameter queries that prompt for a beginning date and an ending date. The same begin and end date is used for all. When running the master report, you are thus prompted for a start and end date 10 times.

I created a form to capture the 2 dates, and I would like to pass them to the master report so that it is opened automatically without all the prompting.

Can anyone help?

 

[KenReay]

Hi

If the Form which allows you to input the dates is open when teh report runs, simply cahnge teh queries so taht the criteria [Begin Date] {End Date] or whatever is replaced by the form controls in the style Forms!frmMyForm!BeginDate, in the query designer, there is a builder button to help your through this

Regards

Ken Reay
Freelance Solutions Developer
Boldon Information Systems Ltd
Website needs upgrading, but for now -

http://www.kenneth.reay.btinternet.co.uk

UK