I've created a form to serve as a dialog box. Instead of getting several parameter boxes prompting me to open my report I want this dialog box to pop up and I will put in necessary information to open the report. This is what I put in the criteria section of my query: between[forms]![diaglog box]![beginning date]and[forms]![dialog box]![ending date] Why won't this form open when I try to open my report?

You must open the form yourself in code. Then use a button on the form to run the report. The form must remain open until the report finishes.

Pat:

I'm very new at this. What do you mean when you say "open the form in code"?

I can't tell from your post how you are opening the report. If you are opening it from a form, change the form to open the parameter dialog rather than the report and then have that form open the report. If you are opening the report by choosing it from the report tab in the database window, you'll need to change the procedure to open the parameter dialog rather than the report.

Thanks for your help!