I need to limit my details on each page of my report with out losing my Group footer. When I used the suggested solution that was out there.
Private Sub Detail_Format(Cancel As Integer, FormatCount As Integer)
If txtrowcount Mod 14 = 0 Then
Detail.ForceNewPage = 2 ' after section
Detail.ForceNewPage = 0 ' none
Using the running sum property and the textbox =1. It worked for the details but I lost my sum that was in the Group footer. I then tried putting my Sum in the page footer (the page footer still shows up) but the Sum in the page footer does not work. Do you have any suggestions?