Resetting Page#/Total Pages for a Section

[KimH2000]

I have created a report to print notes for a large number of insurance claims in order to place hard copies of the notes into individual paper files. There are multiple pages of notes for each claim.

I set the "force a new page after section" option in the claim number footer to yes. Now I want the page footer to display "Page n of n", but would like the page number to start with 1 for each new claim number and show the total number of pages for that claim only.

I have been able to start the page numbering with 1 for each claim number, but cannot seem to reset the total number of pages for each section. I tried increasing a global variable by one for each page in the section using the OnFormat event of the Group Footer. Unfortunately it prints the variable in the footer before the end of the section and I end up with "Page 1 of 1", "Page 2 of 2", "Page 3 of 3" and then back to "Page 1 of 1" for each new set of claim notes.

Any suggestions would be greatly appreciated.

Thanks!
Kim

 

[PaulBricker]

Here is a link to the Access Web. The code on this page will do what you want.
Paul

http://www.mvps.org/access/reports/rpt0013.htm