Print multiple copies of a report with varying criteria from one command button?

[KyleB]

Is it even possible to programatically change the criteria and resend a report? At present if I want to run a report for every month of the year, (not summarize, but a detailed report for each month in sequence) then I have to manually change my time period and click the command button to run the report for each month individually. What I would like to do is have two control boxes, one for the start month, and one for the end month, and click my command button, and have the code look at the two months/years and run the report for each month between, and including those two dates, and send them sequentially to the printer. I'm not certain this is possible, since I would somehow need to programatically change the current parameter values between each run of the same report, and so far have had no luck doing so.

Kyle

 

[KyleB]

Unfortunately I'm not sure I see this as a viable option. My final report is actually an aggregate of 7 sub-reports. It's possible I set up those sub-reports incorrectly, as each one is based on one or more queries that all refer back to a control box date on my switchboard for filtering parameters. Running date ranges on each individual sub-report I could see, if I were to print each sub-report individually; however, I don't immediately see a way to do that with it set up the way it is now. At the moment the only way I can figure this out is via a DoLoop in VBA.