Automate printing of report to file

[slames]

On pressing a button on a form I want a series of reports to be generated and printed to file, how can I automate this so the user doesn't have to select each report and print them to file individually?

Thanks
Steph

 

[PWise]

i dont know what you mean by printing to a file but you put whatever you use for 1 report many times
with docmd
.openreport "report1"
.openreport "report2"
.openreport "report3"
end with

 

[CosmoKramer]

Probably the easiest way is to use a macro and the Output To action.

In the Arguments section on the bottom of the screen you specify which report, the output format you want, where you want it to go, etc.