S
scott04
I have several yes/no boxes that i am trying to code but am running into
problems.
The main yes/no box is named system_issue and have 4 yes/no linked to that
lets name them box1, box2, box3, and box4 just to make it easier. I already
have it coded so that if the box is selected as No then all the 4 boxes
automatically set to no. See below:
Private Sub System_issue_AfterUpdate()
If Me.Systemissue = False Then
Me.box1 = False
Me.box2 = False
Me.box3 = False
Me.box4 = False
End If
My question is how do i code it so that if the answer is yes it requires
that at least one or more of the 4 boxes contain a yes? Any thoughts or
suggestions?
problems.
The main yes/no box is named system_issue and have 4 yes/no linked to that
lets name them box1, box2, box3, and box4 just to make it easier. I already
have it coded so that if the box is selected as No then all the 4 boxes
automatically set to no. See below:
Private Sub System_issue_AfterUpdate()
If Me.Systemissue = False Then
Me.box1 = False
Me.box2 = False
Me.box3 = False
Me.box4 = False
End If
My question is how do i code it so that if the answer is yes it requires
that at least one or more of the 4 boxes contain a yes? Any thoughts or
suggestions?