how to get page no. on group level section (1 Viewer)

[Falcon88]

hi
i have a report with group level section , i use this code :

Private Sub G1Header_Format(Cancel As Integer, FormatCount As Integer)
If Me.InsurCmpName = 3 Then
Me.G1Header.ForceNewPage = 1
End If
End Sub

how to get the page no. of that section exactly not to all the report ?

 

[The_Doc_Man]

Report.Page property (Access)

Office VBA reference topic

docs.microsoft.com

Me.Pages is the total number of pages in the report. Me.Page is the current page's number. If you are in VBA at the time, of course.

 

[isladogs]

See the code in my article:

Report Group Pages

If you use grouping in a report, you may wish to restart the page numbering for each group. This article explains how you can do so.

www.isladogs.co.uk