when I print report it asks me for parameters again...

[Guest]

I have a report that shows the results of several queries that all use the
same parameters. The user enters the parameters (2 dates) through a form I
have created. The report produces the correct results and opens in print
preview.

However, when I then click print, it asks me for all the parameter values
again. How do I get it to print what has already been created on screen?

Or should I just send it straight to the printer from the form without
opening in print preview?

Thanks in advance!

 

[Allen Browne]

See:
Limiting a Report to a Date Range
at:
http://allenbrowne.com/casu-08.html

If you use Method 2, and leave the form open in the background, it won't ask
for the parameters again.

 

[Guest]

Thanks Allen,

My date entry form works ok for now, just getting rid of the docmd.close
from the open report button has solved my problem for now.

That date entry form info will be very useful in the future!