djburnheim
Technical User
I'm sure this is very easy but I just can't find a way to do it....I have 4 checkboxes in a frame on a form, 2 lots of YES/NO. I want the user to be only able to check one, ie yes or no. I've tried using if then for the click event but this doesn't seem to work properly and actually crashes my machine. The best I have is below but if on is checked you seem to have to click on the other twice, eg if Yes is checked, clicking on No once unchecks Yes but you then have to click again to check No???
Private Sub chkYes1_Click()
chkNo1.Value = False
End Sub
Private Sub chkNo1_Click()
chkYes1.Value = False
End Sub
Any suggestions?
Private Sub chkYes1_Click()
chkNo1.Value = False
End Sub
Private Sub chkNo1_Click()
chkYes1.Value = False
End Sub
Any suggestions?