Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations SkipVought on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Can I print multiple reports from one print button on a form? 1

Status
Not open for further replies.

mikj01

Technical User
May 31, 2001
9
0
0
CA
RE:printing a report on current record-thread703-81521
I am still pretty new to access.
The above listed thread shows how to print a report for only the current Record. Can I use this to print multiple related reports for the current record by stringing the names together in the "stDocName=" line? If so what is the syntax?
The same key field is used for each one and all are generated using the same primary form, only the subforms cahnge in each one. I would like to put the button on the primary form, to print all 4 reports.
 
The actual syntax for printing a report is...

Docmd.OpenReport "ReportName"

If you want to print multiple reports then you would say

Docmd.OpenReport "ReportName1"
Docmd.OpenReport "ReportName2"
Docmd.OpenReport "ReportName3"

B-)
ljprodev@yahoo.com
ProDev
MS Access Applications
 
Thanks Lonnie

I got shuffled off onto another project for a week, and just got back to this.

Mike
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top