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

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

CPWorkington - 17 May 2007 18:39 GMT

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.

Reply to this Message

Rick Brandt - 17 May 2007 19:00 GMT

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

Signature

Rick Brandt, Microsoft Access MVP
Email (as appropriate) to...
RBrandt at Hunter dot com

Reply to this Message