Printing Multiple Reports from one report

[asenft]

Is there a way that you can have other reports print when you select print on one report? Basically, i have one main report with a few other reports that i would like to have printed when the main report is printed, without having to select print for the other reports.

Thanks!

-Aaron

 

[TheWildHare]

Place the other reports as subreport object in you main report's Report FOOTER section. YOu can make them invisible so they don't show on the screen.

OR...

Place calls to the Docmd.OpenReport method, naming the other reports, in your main report's ON CLOSE or On Deactivate event.

Either way should work - depends on whether you want print preview features...

 

[papparuff]

On the command button you use to print the report just add each report to print. For example:

stDocName = "rptBirthdays"
stLinkCriteria
DoCmd.OpenReport stDocName, acPreview, , stLinkCriteria

stDocName = "rptParentList"
stLinkCriteria
DoCmd.OpenReport stDocName, acPreview, , stLinkCriteria

stDocName = "rptGrandParentList"
stLinkCriteria
DoCmd.OpenReport stDocName, acPreview, , stLinkCriteria

John Ruff - The Eternal Optimist

 

[asenft]

Thanks for the suggestions! Those will work if i print the reports via command buttons, but what if the user opens the report into Print Preview mode, and selects print there? Will they all still print out?

-Aaron