Checkboxes versus an Option Group

[mraetrudeaujr]

Right now I am using check boxes for a few fields. I am building a form that will have these fields (check boxes) for the data entry. I don't want more than one of these check boxes 'checked' at a time. In other words, they will be given these check boxes as choices, and I don't want them to be able to check more than one box at a time for this particular record. I thought about using an Option Group, but then that would mean deleting (or hiding) these 'check box' fields. This will make it tedious to go back and 'query' the information from these fields. So, how should I proceed?

 

[imterpsfan3]

The usual UI technique is to use check boxes for allowing the user to select multiple items and option buttons when you want to allow the user to only select one item out of several.

I put an option group or frame control on the form and put the option buttons in the option group. You can then bind the option group to a database field.

Or you could just use a combo box.