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

C

CPWorkington

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.
 
R

Rick Brandt

CPWorkington said:
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.
Click to expand...

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.
 
Top