How to print all reports in click?

[eneyardi]

It is possible to print all records in one click? for example i have Report name: Report1, Report2 and Report3 and in a form i have a combolist of employee1 and employee2, I want to print all 3 reports when i select either employee1 or employee2.

[colintis]

You can use VBA from the on_click event to print reports one-by-one. A bit annoying method, but it should work along.

DoCmd.OpenReport "[report name]", acNormal, , "[Parameters]"

Reports![report name].Visible = False

DoCmd.SelectObject acReport, "[report name]", True

DoCmd.PrintOut acPrintAll

DoCmd.Close acReport, "[report name]"

Repeat the above code for every report you need to print within the on_click event. Hope this works.