Parameter values when opening reports.

[jk12]

Hi all, i'm looking for help.

In my database I have 5 reports based on 5 different queries. I have a command button which will print each report off at once but because they each open with a parameter requesting a week commencing (required so they can be printed seperatly, if one report is lost), the person printing is required to enter the same week commencing 5 times which is very annoying. I was wondering if there is a way to have the value entered into the first parameter carried over to or set as the value for the other 4 parameters. Basically I want to be able to enter a week commencing into the first parameter only and have all the following parameter use that value as well without having to type it in.

Thanks in advance for any ideas.

 

[Ziggy1]

use a form to pass the values to the queries. Add an unbound text control to the form.
replace your parameter criteria with (but with your name references):

[Forms]![YourFormName]![YourControlName]

when the button is pressed your queries will refer to the form for the criteria, you should have a macro or VBA to run all 5 reports in succession and you will only have to enter the date once.

Ziggy