Help! Query on Form 1

[RDM23]

I have a form where I need to audit to see if either of the options are checked. Something like If Field1=-1 or Field2=-1,"Yes","No. (This is for a checkbox on a form. I need to ensure that only Field1 or Field2 is checked which would display a -1. This is just an audit on the bottom of the page that checks to see if one of these fields is checked. Thanks in advance.

 

[lameid]

To fix your expression for use on a form...

Controlsource:

= IIf (Field1 Or Field2,"Yes","No")

Although your text describes you want only one of the checkboxes checked which implies not both.

Controlsource:

= IIf (Field1 XOR Field2,"Yes","No")

 

[RDM23]

Thanks for the response lameid. That worked great. Another question I have is this. On the form, I have Field 1 and Field 2 as the checkbox options. If they select checkbox field 1, then select checkbox field 2, I would like to have checkbox field 1 to go unchecked. This would allow them to only check 1 or the other. Currently they can select both checkbox field 1 and checkbox field 2.
Thanks.

 

[PHV]

Why not using an OptionGroup ?

Hope This Helps, PH.
FAQ219-2884
FAQ181-2886

 

[RDM23]

Great Idea. Thanks so much for you help. Very much appreciated.