Check box on or off capability

[Tony A via AccessMonster.com]

I have 7 check boxes per row. I only want the user to check one of them. If
the user checks checkbox1, none of the others are checked and if checkbox4 is
checked, then checkbox1 is unchecked.

Is this possible with check boxes? Please help with the code to turn on or
off.

Thanks,
Tony

 

[Rob Oldfield]

There's no code required. Just add an option group to the form and bind
that to your data field* and then add seven check boxes** to it with their
option values set to 1 to 7.

* ...assuming that you have one numeric field instead of seven boolean
fields
** ...although option buttons would be better as they fit the standard
Windows design model.

 

[Guest]

You need radio buttons not checkboxes. They are designed for just that purpose.

Dorian