Closing a parameter form on Report Load

[uaguy3005]

I have a sub-form I use to pass parameters to a couple of queries that generate some data that I show on a chart in an access report. The problem I have is that I when I close the sub-form I used to pass the parameters, then when I try to print the report it prompts me for the dates I passed again. So how do I get the report to stay open, be able to print it without it trying to re query?

[pbaldy]

To the best of my knowledge the report will always try to requery when you print it. You can close the form in the report's close event rather than the load event.

[uaguy3005]

So how would I hide the subform then until the close event?

[pbaldy]

You can set its Visible property to False.