Printing multiple reports using one query parameter

[rdkirb49]

I have a database with 13 reports. I need a way to print all the reports without having to reenter the parameter for each report. I tried using a form, I also set up macros with open query on the top. In each instance, I had to enter the query parameter for each record. Is there anyway to do this??? I don't know code, but I am real good with copy and paste ;}... Please help.

Reg

 

[dhookom]

This is a major issue with using parameter prompts. Replace all parameter queries with references to text boxes (or other controls) on forms.

Duane
MS Access MVP
Find out how to get great answers faq219-2884.

 

[wemeier]

Replace all of your parameters with a reference to your form field. For example:

WHERE City=[Enter City]

becomes:

WHERE City=Forms!frmEnterCriteria!CityParm

This, of course, assumes that you have a textbox or combobox named CityParm in a form named frmEnterCriteria.


Cruising the Information Superhighway
_{(your mileage may vary)}