Prompt for report problem

[1andyw]

My application produces six reports, the source of each is a single query. I prompt the user for input by placing [enter data here] within one criteria area of the query. My macro opens the query, then closes the query, then opens each of the six reports. The user is prompted for each and every report. How can I alter this to have only one prompt?

Problem Solved. Thanks for your help.

 

[sfreeman@co.mer]

Why

Why do you open the query first?

Just open the report.

 

[1andyw]

My initial macro only opened the report. I added the open and close query to the macro to try to eliminate the numerous prompts. Did not make a difference. I am still prompted by the query for each report.

 

[WayneRyan]

1,

Make a small form "frmPrintReport" with a textbox called "txtEnterData"
and a Command Button on it.

For each query that feeds your report, use the Criteria section to put:

Forms![frmPrintReport]![txtEnterData]

Finally, on your frmPrintReport, put this code behind the Command button:

DoCmd.OpenReport "Report1"
DoCmd.OpenReport "Report2"
DoCmd.OpenReport "Report3"
DoCmd.OpenReport "Report4"
DoCmd.OpenReport "Report5"
DoCmd.OpenReport "Report6"

That should do it:

1) Open frmPrintReport
2) Enter the appropriate data
3) Hit the Command button

Wayne

 

[1andyw]

Wayne,

That is the solution. Thank you. Works like a charm.

Andy