Printing reports from a button on a form

[mark_jm via AccessMonster.com]

Can I print 1 or more reports from a single button on a form without
previewing the reports first?

 

[Al Campagna]

mark,
Yes, just chain them together...

Private Sub cmdReports_Click()
DoCmd.OpenReport "Report1"
DoCmd.OpenReport "Report2"
End Sub
--
hth
Al Campagna
Microsoft Access MVP
http://home.comcast.net/~cccsolutions/index.html

"Find a job that you love... and you'll never work a day in your life."

 

[mark_jm via AccessMonster.com]

But can I print with out viewing the reports, presumably .OpenReport opens
the report but dosnt print?

 

[Al Campagna]

mark,
The OpenReport method prints the report immediately, as long as you
haven't specified acViewPreview in the OpenReport "View" argument.
See OpenReport mMethod in Help...
My code, as posted, prints each report immediately... one after the
other.
--
hth
Al Campagna
Microsoft Access MVP
http://home.comcast.net/~cccsolutions/index.html

"Find a job that you love... and you'll never work a day in your life."