Report Conditional Hide Section

[GendoPose]

Hi All,

I have master and child fields in my query, and in my report I have blank controls where there is no child record to the master. I'm trying to set the section (Group Header and Detail) to be invisible when there's no value in a control. However, as soon as I introduce an If statement to the VBA in a report, regardless of the event I put it in, it just stops working completely.

Anyone got any ideas?

Thanks!

 

[vbaInet]

You've not explained this bit clearly.

I have master and child fields in my query, and in my report I have blank controls where there is no child record to the master.

But perhaps you mean this:
http://www.access-programmers.co.uk/forums/showthread.php?t=267698