Multiple report using same query

[OAKLEYS21]

Hello,

I have several reports with sub reports that all use the same query. I want to open them all at once with the same set of criteria. I created a macro to do it except when I run the macro I have to enter the same parameter value 6 times to open the different reports at the same time. (it prompts me 6 time to "enter lease number") Is there a way I can set either the reports or the macro so that I can only enter the criteria once? Thanks.

 

[randy700]

Change the query to get the lease number from your form.
On the criteria line...=Forms!frmYourForm!txtLeaseNumber


Randy

 

[OAKLEYS21]

Thanks Randy,

Unfortunatley that didn't work any other ideas? that I can try??