Access with multiple yes/no boxes allow only one box to be picked

[Guest]

I am designing a database in Access 2002 and want to offer the options of
Complaint, Compliment or Enquiry. I am using yes/no box for each option and
want to create a rule whereby only one box can be picked.

 

[Rick Brandt]

I am designing a database in Access 2002 and want to offer the
options of Complaint, Compliment or Enquiry. I am using yes/no box
for each option and want to create a rule whereby only one box can be
picked.

Use one field instead of three where you store...

1
2
3

....to represent Complaint, Compliment, and Enquiry respectively. Then you
use an OptionGroup frame with three RadioButtons (one for each choice).
Then the OptionGroup automatically enforces the one-choice-only feature.