Can I setup two checkbox so that you can only check one at a time

[JonH]

I have two checkbox's which refer to different fields in a table. These
checkbox's are yes/no and will be on a form which allows the user to perform
a query. However, I would like the user to be able to only choose one
checkbox at a time so that I minimizes the amount of hits the query turns up.
Is there an expression/macro that I can write in the properties of these two
checkbox's so that when one is clicked the other is Null and vice versa? It
will end up being like an option box to the user on the form, but I can't use
the option box since there are two different fields involved.

Thanks

 

[Douglas J. Steele]

Already answered in another newsgroup to which you posted the same question.

If you feel you need to post to more than one group (HINT: it's seldom
necessary), please have the courtesy to cross-post (send the one message to
all groups at once), rather than multi-post (send individual messages to
each group). In this way, all responses to your post will be available
together, regardless of what group the responder was in, and the rest of us
won't have to read your post multiple times. (It also uses fewer server
resources)

If you're using Microsoft's web interface to post, you should see an
"Advanced Options" link at the bottom of the page. You can type the names of
the various groups into the Newsgroup box, separating each newsgroup name
with a semicolon.

Note that it's generally consider to be A Bad Thing to cross-post to more
than about 2 or 3 newsgroups.

 

[Paolo]

Hi JonH,
Let's say your check boxes are called checkbox1 and checkbox2

On the after update event of checkbox1 put this
checkbox2=0

and on the after update event of checkbox2 put this
checkbox1=0

so when you click on checkbox1 you unselect checkbox2 and viceversa.

HTH Paolo