Multiple Option Buttons - Different Combinations Run Different Queries

[DWhit12692]

Hey Everyone!



Fairly new to Access.

I have two option buttons on different parts of my form that are not in a group and i don't want them to be in a group.

I am trying to build the event for a button on my form to do the following:
If option 1 is true and option 2 is true, run query A
If option 1 is true and option 2 is false, run query B
If option 1 is false and option 2 is true, run query C
If option 1 is false and option 2 is false, run query D

HOWEVER, i cant get the second scenario (option 1 true and option 2 false) to work even if i set it as the only IF statement. Access runs the Else query no matter what. (Sorry if my lingo isn't quite right... I'm an Excel guy)

I am able to get the correct query to run using [Option47].[Value]=True And [Option22].[Value]=True
But [Option47].[Value]=True And [Option22].[Value]=False goes straight to the Else.

[pbaldy]

What exactly is your code? Is it possible Option22 is Null rather than False?

FYI, informative names will help you in the long run.

[DWhit12692]

What exactly is your code? Is it possible Option22 is Null rather than False?

FYI, informative names will help you in the long run.

AHHHH!!!! It was such a simple fix. It was indeed "Null" and not "False"! Thank you so much!

And next time, I'll copy and paste the code. Guess that's way easier than trying to explain everything. Thanks again!

[pbaldy]

No problem and welcome to the site by the way!