I have a tabbed Form with 8 tabs. Each tab contains a subform. This particular subform is itself comprised of two subforms. For one of my uses I want to Hide or make not visible one of the subform's subform. Can that be done?
The particular sub/subform I want to hide is on tabbed form Page5, the ControlName of the subform is [MachinePullCashCount]
the sub of that subform I want to make not visible is
In my Private Sub that part of the code was:
Forms![frm_DataReporting]![MachinePullCashCount].Controls("ShiftRprgEndCountDetails_Coins").Visible = False
Since I set the Focus to Page2 and this sub/subform is on Page5 I don't understand why it fails.
I get Run-time error 2165
You can't hide a control that has the focus.