Grouping checkboxes so only one can be checked

[djburnheim]

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?

 

[PHV]

Why not using OptionGroup ?

Hope This Helps, PH.
Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884 or FAQ222-2244

 

[ablackwe]

Try using optionbuttons instead of checkboxes. Each pair of buttons, i.e. Yes and No, will have to be within its own frame. Only one of the 2 buttons can only be selected.

Hope this helps
Adam

 

[KatSoft]

You could use this trick :

in the AfterUpdate of all checkboxes, write some code to change the other checkbox. For example : the code for the first pair of checkboxes:

Private Sub chkYes1_AfterUpdate()
chkNo1.Value = Not(chkYes1.Value)
End Sub

Private Sub chkNo1_AfterUpdate()
chkYes1.Value = Not(chkNo1.Value)
End Sub


Like this, no matter what the user clicks, it will always "unclick" the opposite.