Make report group footer visible

[Sean G.]

Hello,

I'm trying to make a group footer visible depending on a
question on a form. However, my code is causing another
group's footer to be visible or not. Here is my code:

Private Sub GroupFooter0_Format(Cancel As Integer,
FormatCount As Integer)

If Forms!frmParam_RevenueCriteriaClientGroup.question
= "Yes" Then
Me.Section(acGroupLevel1Footer).Visible = True
Else
Me.Section(acGroupLevel1Footer).Visible = False
End If

End Sub

How do I know what grouplevel my footer is?

Thank You.

-Sean