VBA Question

I'm VERY new to VBA so please bear with me. I am working in a database that has tab controls with check boxes. I am trying to force the user to check at least one of the controls. If they don't, they can't move on to the next panel where it will require them to do the same on this tab control and so on and so on. Once they have made at least one choice in each tab control, they can then exit the form. Any ideas would really help. Thanks

Well, I wonder if you can disallow changing tabs until a box is checked on the active tab? Could you just set the tab's enabled property to false until a box is checked? How many tabs do you have? Do they have to be accessed and checked in a certain order?

This will do what you are looking for, however if someone checks the box and then unchecked it they will still be able to move on. You can easily change the code so that it will re hide the tab but if you are using more then one check box you will need to loop thru the controls to set every time one isunchecks to see if all of the boxes = false You will also want to set the vi sable property of tab 2 to false in design mode so that the tab is not visable when the form loads you can also do this in the form_load event in VBA if you would rather do it all in code.


Private Sub Check1_Click()

If Check1.Value = True Then
If Page2.Visible = False Then
Page2.Visible = True
End If
End If



End Sub