Repost-How to print 2 reports in order?

M

MN

Hi,
I have 2 reports named Report1 and Report2. In VBA I do:
Docmd.OpenReport "Report1", AcViewPreview
Docmd.OpenReport "Report2", AcViewPreview

Report1 have 2 pages, Report2 have 2 pages print out too.
How can I print in the order of:
Report1 - Page1 print out then they will print Report2 Page1,
samething for page 2: Report1-Page2 then Report2-Page2
And
Assume they print out 4 pages-How can I number all of them like Page 1 of 4,
Page2 of 4...?
Thank you for all reply - MN
 
P

Paul Hammond

You could put Report 2 in the Report footer of Report1 as a subreport.

Paul Hammond
Richmond, VA
 
M

MN

Thank you Paul,
I will do that.
Regards,
MN

Paul Hammond said:
You could put Report 2 in the Report footer of Report1 as a subreport.

Paul Hammond
Richmond, VA
Click to expand...
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

How to print 2 reports in order? 0
batch print some specific pages in multiple word files 1
How to print an A4 document to 2 A5s 0
Stop header/footer appearing in subreport 1
Report Sorting Problem 1
Adding values from sub reports in the main report 8
Print Multiple Reports from one button 1
Page numbering with Merged Document and IF statements 1

Top