run a half dozen reports from 1 click

[techexpressinc]

Can I trigger 6 reports to be run a the same time?


Thanks Russ

[Cheshire101]

Are you using a button on a form?
if so, in the "on Click" property filed select event procedure
and use the code
DoCmd.OpenReport "YourReportName"
DoCmd.OpenReport "YourReportName2"
DoCmd.OpenReport "YourReportName3".....and so on

[techexpressinc]

I will try the form. I have way too much manual editting time running reports weekly.

My final output is 18 pdf report documents.

Currently, i run 2 reports in two different databases. The agencies are together with page breaks. I convert the document to PDF and save on my local drive then open the pdf document up in Adobe Acrobat and split the report apart by agency.

The process ends up being a couple hours. I like to trim down to less.

Russ