Custom Page Numbering Help

[RayMilhon]

I have a large report in MS Access 2010 The report contains 3 Group sections. I have the report set to create a new page when the first group section changes. I would like the Page Number to reset to 1 when this happens. Anybody have an idea on how to do this. I tried creating a long Integer variable in the report and in the Group Header On format event set the variable = 1. I set an unbound text box in the page footer section and placed code in the onformat event of the page footer section to set the unbound text box = to the variable and increment the variable. I ended up with Page 1 on every page. HHHEEEELLLLLPPPPP!

[June7]

See if this helps http://office.microsoft.com/en-us/ac...005187401.aspx

[RayMilhon]

Thanks June 7 That led me to the answer. It didn't work directly because I was Repeating the Header on each page so every page was 1 but with a little code in the Onformat event of the header I got it to work. I created a Private Variable for the report and set the Variable = to the Group Field. Then added an if statement

If strvar = "" then
strvar = pcpid
Else
If strvar <> pcpid Then
Runmacro "macnewpage"
strvar = pcpid
End if
End if

That worked perfectly