A2K: Subreport not Visible, Header not Visible

[Freckles]

In my report at OnFormat, I need to say that if subreport [RR_BLIP Report State] in [GroupFooter3] has no data, then [GroupHeader5]is not visible.

Have I got too many parameters?

: Deb Koplen
deb.koplen@verizon.com
koplend@swbell.net (weekends and nights)

A person can stand almost anything except a succession of ordinary days.

 

[dhookom]

If Me.[RR_BLIP Report State].Report.HasData = True Then
Me.Section("GroupHeader5&quot.Visible = True
Else
Me.Section("GroupHeader5&quot.Visible = False
End If

If this doesn't work, you might want to add code to the On Format event of GroupHeader5
Cancel = (Me.[RR_BLIP Report State].Report.HasData = False)

Duane
MS Access MVP
Find out how to get great answers faq219-2884.

 

[Freckles]

thanks for your complete answer, but, sorry to report, neither worked.

I copied and pasted your first suggestion in "on format" for GroupFooter3 and got back "Run Time Error 3465" "Microsoft Access can't find the field 'Forms' referred to in your expression."

And I got the same message when I copied and pasted the other suggestion in GroupHeader5

: Deb Koplen
deb.koplen@verizon.com
koplend@swbell.net (weekends and nights)

A person can stand almost anything except a succession of ordinary days.

 

[dhookom]

I don't see "Forms" anywhere in the code I sent to you. I suppose this is one of those cryptic messages that has nothing to do with the actual error. Does the error break in the code? If so, what line? Have you attempted to use intellisense to allow Access to complete the syntax of the statements? Is your subreport control named "RR_BLIP Report State"?

Duane
MS Access MVP
Find out how to get great answers faq219-2884.