Sub-form reference incorrect?

[GraeagleBill]

I have a subform where I'm wanting to toggle the visibility property depending on changes to the sub-forms recordsource.



Here's the code: (snipit)
If bolautobraodcast = True Then
Me.RegistryNamesOnlyFiltered.Controls(lblBroadcast ).Visible = True
Me.RegistryNamesOnlyFiltered.Controls(chkBroadcast ).Visible = True
Else
Me.RegistryNamesOnlyFiltered.Controls(lblBroadcast ).Visible = False
Me.RegistryNamesOnlyFiltered.Controls(chkBroadcast ).Visible = False
End If

The code runs okay as I step through in Debug, but two fields remain visible when the code path sets them False.

Is my sub-form reference incorrect?

Thanks,
Bill

[pbaldy]

Is RegistryNamesOnlyFiltered the name of the subform? Try

Me.RegistryNamesOnlyFiltered.Form.Controls("lblBroadcast").Visible = True

Note additions in red.

[GraeagleBill]

Hi Paul,
That did the trick. And yes, RegistryNamesOnlyFiltered is the name of the sub-form.

Some old code I'm adding to.......so old that Options Explicit not turned on, as is my practice now. Just happened to notice that and compiler complained about the un-quoted field names as soon as I turned option on. I think I might have thought about the controls collection needing the quotes had the compiler complained initially.

Reno is supposed to get hammered on Sunday. We've had pretty close to 10 inches of rain since Monday here in Graeagle. Little Graeagle creek looks like the Truckee now. And the Feather looking pretty close to the Mississippi.

Thanks,
Bill

[pbaldy]

No problem Bill. It has been raining most of the day. I was hoping it was snow in the higher elevations. I hope we don't have any flooding issues. All that rain up there is a concern, as you know. Luckily we live on a ridge, so if water gets up to our house, we'll catch a ride from Noah.