1st subreport is accurate, 2nd less, all others not

[tstoneami]

I felt I owed this forum an answer. It was a tough go and in the end it turned out to be simple. The control states in the report don't return to their default initial setting on each report in the batch. So, because I am messing the the visibillity, as soon as I expose something it remains exposed for the entire run. The simple fix was to set all the controls invisible at the outset of the form event code:

Dim ctlCurr As Control Dim booCondition As Boolean For Each ctlCurr In Me.Controls If ctlCurr.Tag = "Group1" Then ctlCurr.Visible = booCondition End If Next ctlCurr

It also goes back to an earlier post about tags. In this use of tag I just use it to tag all the controls and set the visibility in one go.

Thank you for any interest in helping me. June - this is the real issue.

Troy

[June7]

Glad you found a solution.

Interesting that in one of my tests it seemed that the visibility turned off/on for the entire dataset, which did surprise me. I saw it on for a record midway then the following records did not show it.

I was thinking of an alternative to the VBA since it appears it is the label that you really need to make not show.

Maybe use a textbox as the label and then an expression in ControlSource like:

=IIf(IsNull([fieldname], "", "label text here")

Eliminates VBA and report will render much faster.