Prompted for Parameters AGAIN when Printing Report

[kmkland]

When I run my report (which contains 2 subreports - the main report is just a shell holding the 2 subreports), I am prompted for my parameters. BUT when I print the report, I am prompted again! Is there any way that I can alter my report, queries or parameters to stop this from happening?
Thanks in advance.
Kim

 

[PHV]

You may consider have a form with TextBoxes referenced by the query.

Hope This Helps, PH.
Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884 or FAQ222-2244

 

[kmkland]

PH,
I do not understand what you mean.
I want to print my reports, which contain 2 subreports, but I do not want to enter my parameters twice. These 2 subreports have 2 separate queries. I'm not sure I follow how a form with text boxes referencing the query(-ies) will work.
Please, elaborate for me so I will better understand where you are coming from.
Thank you so much.
Kindest regards,
Kim

 

[cghoga]

Say for example you have a BeginDate param and an EndDate param.
Create a form with 2 unbound textboxes, one named BeginDate the other EndDate.
In your queries reference the field values on your form.
So, if your form is named Form1, the query reference would look like:
Forms!Form1!BeginDate.value etc.

Hope this helps.

 

[kmkland]

Thanks so much for your help!!!
Kim