My problem is with 2 group headers in a report: GroupHeader0 and GroupHeader1. I want GroupHeader0 to print only on the first page of every group and GroupHeader1 to not print on page 1 of every group (or print on all other pages but page 1). I've tried the following code in various iterations:
Private Sub GroupHeader1_Print(Cancel As Integer, PrintCount As Integer)
If Page = 1 Then
GroupHeader1.Visible = False
GroupHeader1.Visible = True
But this turns the header off for the whole report, except page 1, not on a page-by-page basis. That is, it turns GroupHeader1 off after page 1 for the rest of the report - even when Page 1 comes up again as the first page of the next group (I reset the Page var after the GroupFooter0). Originally, I tried this with a page header, but couldn't make that work either - so I'm trying two group headers.
I think I may have the event, wrong, too - but I tried this in the Format event, too without success.
What the heck am I doing wrong? (Besides having chosen the wrong career...:-)
Let me know if I've been unclear - I'm running Access 2002 on a Win98 machine.