Reporting results of a parameter query?

[ShannonSkipper]

I have a form that gives the parameters to a paraemeter query. What I want to do is make a report from the results of the parameter query. How do I tell the report that I want it to use the results of the query?

Thanks,
Shannon

 

[dhookom]

Set the Record Source property of the report to your query.

Duane
MS Access MVP
Find out how to get great answers faq219-2884.

 

[ShannonSkipper]

The Record Source property does point to my query - but instead of bringing up the form to enter parameters it just prompts me for the parameters one at a time. Any way to get the report to open the form to prompt for the parameters automatically?

Thanks,
Shannon

 

[dhookom]

I usually open the form first and then the report. You can try code in the On Open event of the report:
DoCmd.OpenForm "frmYourForm", , , , , acDialog
After entering the parameters, make the form invisible so you can see the report.

Duane
MS Access MVP
Find out how to get great answers faq219-2884.