I think I am stuck. Here is what my form set up is.
I have 10 check boxes. The 10th check box, I only want to be enabled if either check box 2 or 7 or both are checked. so, to summarize:
[ul]
[li]If 2 and 7 are both checked, it is enabled, regarless what else is or isn't checked.
[li]If 2 is checked and 7 is not checked, it is enabled, regarless what else is or isn't checked.
[li]If 7 is checked and 2 is not checked, it is enabled, regarless what else is or isn't checked.
[li]If neither 2 nor 7 are checked, it is not enabled, regarless what else is or isn't checked.
[/ul]
What I have working so far. If check box 2 is checked, it is enabled, otherwise, it is not. See my code below (which was taken from another thread, so thank you)
--------------------------------------------
--------------------------------------------
Any suggestions?
Thanks
I have 10 check boxes. The 10th check box, I only want to be enabled if either check box 2 or 7 or both are checked. so, to summarize:
[ul]
[li]If 2 and 7 are both checked, it is enabled, regarless what else is or isn't checked.
[li]If 2 is checked and 7 is not checked, it is enabled, regarless what else is or isn't checked.
[li]If 7 is checked and 2 is not checked, it is enabled, regarless what else is or isn't checked.
[li]If neither 2 nor 7 are checked, it is not enabled, regarless what else is or isn't checked.
[/ul]
What I have working so far. If check box 2 is checked, it is enabled, otherwise, it is not. See my code below (which was taken from another thread, so thank you)
--------------------------------------------
Code:
Private Sub check2_Click()
If check2.Value = "0" Then
check10.Enabled = False
Else
check10.Enabled = True
End If
End Sub
Any suggestions?
Thanks