Help!

[junmart]

I have a query that prompts users for a parameter. the results of the query is outputted to a form. on this form, i have a command button to preview a report based on this query. the problem is whenever i run the report, the same dialog box prompts me for the parameter. how can i get rid of this redundant dialog box? basicaly i just want a report of the parameter based query results. please help me! thanks in advance!

 

[lscheer]

Why not just skip opening the form based on the parameter query? Just open the report based on the query to eliminate 2 steps.

 

[Pat Hartman]

The query prompts for the parameter and the query needs to be run a second time to produce the report. That is why you get two prompts.

To avoid this, create a form where the parameters are entered and change the query's criteria to refer to the form fields rather than prompting. As long as the form is still open when the report runs, you won't see the prompts.