allow only one check box to be ticked

[Slow Learner]

I have a form with 4 check boxes on it which when ticked put a tick in the corresponding field on a report. I only want one tick to be allowed for each record. I see this can be done by creating an option group box but when I put my check boxes in the group box they do not allow me to check only one and show that as a check in the table.
How would I group my check boxes into a group box?
Thanks

 

[john471]

He there,

Firstly, I recommend you consider using option buttons (aka radio buttons) for this purpose instead. Typically useage of these is for mutually exclusive options, as per your implied purpose. Check Boxes, IMHO should be used for combinable options (i.e. select none or more).

Whichever way you decide to go, the Option Group (aka Frame) should meet your needs. The trick is to create the option group (frame) first. Then create the check boxes or radio buttons inside it. The whole frame will highlight as you create the check box/radio button inside of the frame, if you have done it correctly.

If you have already created all the check boxes, and dont want to delete and re-create, you can "fix" it by "Cutting" the check boxes, then select the frame and, with the frame selected, paste the check boxes. This will associate them with each other. Make sure each check box has a unique "option value" property. If two (or more) have the same value for that property, checking one will check all with the same option value.

The easiest way to then work out which one is checked is to interrogate the value of the frame.

HTH

John.