Multiple Selection, Select Just One

[burrina]

I have several check boxes and want the user to be able to select just one of them.The others should be De-Selected.
Example:

Code: Select all

If Me.admn.Value = -1 Then
    Me.sprvsr.Value = 0
    Me.data.Value = 0
    Me.reado.Value = 0
    Me.exclu.Value = 0
  End If

Must be easier way. I am using the AfterUpdateEvent of the check boxes event. Here are the controls and the data type and format.
admn
sprvsr
data
reado
exclu


Check Boxes
Data Type Yes/No
Format Yes/No



{RESOLVED}

[Rudi]

Ideally you should use option buttons for that. If you can replace the check boxes with option buttons, that will be an immediate advantage (that only one in the group can be selected.)

[HansV]

I'd use option buttons (radio buttons) instead of check boxes. The interface convention is to use option buttons if you want to allow only one choice, and check boxes if you want to allow multiple choices.
Create an Option Group control (frame), and create (or paste) the option buttons in this option group.
Assign a different Option Value to each option button in the Data tab of the Property Sheet, for example 1, 2, 3 and 4.
When you click an option button, Access will automatically turn off the other option buttons in the same option group, without needing any code.

If you do it this way, you don't inspect the value of the individual option buttons (or check boxes) in order to check which one has been selected. Instead, you inspect the value of the option group control. This will be equal to the Option Value of the selected option button. So if you selected the option button with Option Value 3, the value of the option group will be 3.

[burrina]

Can't change design. It is this way for a reason. I understand the reasoning though. This is on a Continuous form.
Thanks,

[HansV]

If you can't place the check boxes in a content control, you'll have to use code like what you posted at the beginning of this thread.

[Pat]

You could use a combo box with just 5 entries, defined as a list