#Name? Error in Report

[kristyspdx]

Hello,

I have a report in which I am trying to hide some rows. See the two attached printscreens. The first printscreen shows the rows (highlighted by yellow box) that I am trying to hide if they have a null value for the "Group of Division Subgroup1" field. I have used the coding below. The second printscreen shows that it works for all but the first group (Strategic Reserves). This grouping still shows the row that should be hidden and inserts a #Name? error. Can anyone help with this?


Private Sub GroupHeader2_Format(Cancel As Integer, FormatCount As Integer)
If IsNull(Me.Group_Of_Division_Subgroup1) Then
Cancel = True
End If


End Sub

[pbaldy]

If your setup is what I think it is, try:

If IsNull(Me.Group_Of_Division_Subgroup1) Then
  Me.GroupHeader2.Visible = False
Else
  Me.GroupHeader2.Visible = True
End If

[kristyspdx]

Tried it. I got the exact same result.

[pbaldy]

Can you post the db here, or a representative sample?

[kristyspdx]

Thanks for your willingness to help. The entire database is too large to post. I've attached a sample with just a few lines from the table that is used to create the report and the report itself. Any help in resolving this issue is appreciated.