Check boxes in query

  • Thread starter Thread starter alecgreen
  • Start date Start date
A

alecgreen

Hi

I have in my query 3 check boxes, which I want to make only one
available to the user - thus making only one option available at a
time. I can achieve this on a form, but not the query - any ideas?

Alec
 
I believe you are trying to set up an option group, not three checkboxes.
If only one of three options is available, the result should be stored in
one single field. An example would be...

If each person in the database is either a "doctor" a "nurse" or an
"intern". You don't want three separate fields, you just want one called
"occupation" or "title". You can create an option group or a drop-down in
your forms to make selection easier.

In answer to your basic question, you don't want to do this in a query.
Your users should be working in forms, not queries, so build all your
conditions into your form and get your users to work there.
 
Back
Top