Repost-How to print 2 reports in order?

[Guest]

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

 

[Guest]

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

Paul Hammond
Richmond, VA

 

[Guest]

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

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

Paul Hammond
Richmond, VA