continuous page numbering w/multiple reports (1 Viewer)

[brian189]

I am printing multiple reports from a form button using vba. I want the first page number of each report to pick up where the previous report left off (if the first report was 8 pages long, I want to start the second report at page 9). Can anyone provide some help with this?

Thanks
Brian

 

[jrs]

Brian,

I have a similar porblem and was searching for an answer. I noticed no one responded to your post from 2001.

Were you able to come up with a solution? If so, can you share it with me.

Thanks in advance

JR

 

[Pat Hartman]

This article from the knowledge base should get you started.

Q100156 - ACC How to Specify a Custom Starting Page Number for a Report

However, it shows a technique that requires prompting. What you need to do is to create a global variable and in the ReportFooter routine of each report, store its final page number in the variable. Then rather than prompting as the kb article suggests, use the variable stored by the previous report.