Resetting Page Number on report footer

[ideafixer]

I have a sub-report in my report footer section. This sub-report gives a summary group totals in my report. I want my page number reset to 1 on the first page of the report footer. If the sub report spans multiple pages on the report footer, I want the page numbers to be 1-4...

I tried:

Global Boolean defined: PageNumberReset

On open event of report:
PageNumberReset = False

On print event of report footer:
If PageNumberReset = False Then
[Page] = 1
PageNumberReset = True
End If

This does not work because the report footer print event happens after the page footer print event. The page numbers do not reset until the second page of the report footer. Does anyone have a suggestion?