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!

Instead of basing anything on a parameter, I'd put a field on the form itself, so users can enter the value. Then, base the query on that field.

I am a newbie, so can you please tell me how go about what you advised?