Printing Multiple reports

[Steve5]

Hello,
I have a select query that is based on a 4-digit report number. The four-digit report number has 4 reports linked to it that need the four-digit code to print the correct information.

Currently when I print from my form button, and it is linked to a macro that has all four reports on it.

However, my problem is the select query parameter window pops up and asks me to put in the 4-digit code in four times as a result of the four reports, which I feel should be possible to simplify.

How can I make it so I place the 4-digit code in once and it sets the parameter for all four reports?

 

[mark curtis]

Well it looks like either the queries that make up the sub-reports have parameter prompts in them or the sub reports have not got the correct master child links set up. Zip up the db and it will be looked at.

 

[Rich]

Use a popup form to input the parameters, change the queries parameters to reference the forms textboxes

 

[Steve5]

Thank you Both!

Let me give your suggestions a try.