I'm trying to figure out the best way to print out a report that's generated from a query where the user inputs specific criteria. What I'm wondering is how to give the user the option to input multiple criteria to print out multiple instances of the same report, but based on the multiple criteria they input.

I looked around but couldn't find any threads relating to this. If there are previous threads for something similar to this, could you point me in the right direction? Thanks.

On the button to open the report, I would open a form on which the user can specify the various criteriacriteria, and then another button to 'Continue" which would loop through the form criteria and preview/print the report as required.

This would probably entail using a query as the report's recordsource and dynamcial rebuilding the query with a qdf for each required iteration, as required.

Otherwise, modify the printer setup on the fly.l