When printing a report, I'm re-prompted for date range

[Timberwolf]

I have a report that contains a subreport that contains a date range. When I run the report, it prompts for the date range and then creates the report just fine. But when I hit my print button, I'm re-prompted for the date range! Arghhhhh!!

(Thanks!)

[This message has been edited by Timberwolf (edited 08-08-2001).]

 

[capri]

just a suggestion, go into design view, right click on the print button and check our the properties.

 

[Pat Hartman]

It prompts you again because it runs the query again to generate the printed copy. To stop this behaviour, you need to change the query so that it gets its parameter from a form field rather than prompting for it. Then as long as the form is still open, the report won't prompt again.