The following will generate page break every 20 records.
Create textbox in Detail section.
Name: tbxCount
ControlSource: =1
RunningSum: OverAll or OverGroup, both worked for me
Code:
Private Sub Detail_Format(Cancel As Integer, FormatCount As Integer)
Me.PageBreak1.Visible = Me.tbxCount Mod 20 = 0
End Sub
Format events only trigger for PrintPreview or direct to printer.
Now for the total.
Another textbox in Detail section.
Name: tbxSum
ControlSource: field to sum
RunningSum: same as above
Another textbox in Page footer.
ControlSource: =tbxSum
Total on each page will be cumulative. If you don't want cumulative, this gets really complicated.