Hi all. I have one form. On the form I have 7 tabs. Each of them has 2 check boxes. I need to run some code so that when the form is loaded, the check boxes are marked to False. I can do this with the check boxes on the form, but not those on the tabs. Here is the code I'm using - keep in mind the check boxes on the tabs are named "chk1...", "chk2..." from 1-7:
For Each ctl In Me.Controls
If ctl.Name Like "chk*" Then
If Mid(ctl.Name, 4, 1) >= 1 And Mid(ctl.Name, 4, 1) <= 7 Then
Select Case Mid(ctl.Name, 4, 1)
Case 1
Me.pag1.Controls(ctl.Name).Value = False 'this is not working
End Select
Else
Me.Controls(ctl.Name).Value = False 'but this works just fine
End If
End If
Next ctl
Any ideas? Thanks a lot!
MW