Help with hidding report footer

[Al]

I work in Access 97 and I have a subreport that I am trying to make it hidden
when certain conditions are met, here is the code:

If parent.[PricingDetails] = "General" Or Me![CredentialCount] = 1
Or Me![CredentialCount] < 1 Then
Me.ReportFooter.Visible = False
Else
Me.ReportFooter.Visible = True
End If
I placed this code in the report footer, detail, and header but nothing
seems to work even thogh the condition is met the footer still shows. any
ideas
thanks
Al

 

[Jeff L]

Put it in the On Format event of the Report.

Hope that helps!