How To Filter with Option Group

[doyle60]

I have a query with a Yes/No field. On a form I have an option group
with these Names and Option Values:

Checked: 1
Unchecked: 2
All: 3

The Option Group is Frame15, if that comes into play.

How do I filter the Yes/No field with this option group? I did it with
a check box but think it will look better with an option group.

Thanks,

Matt

 

[doyle60]

Own problem solved with some nested code. Not the best solution but it
got there.

Matt

 

[Tim Ferguson]

How do I filter the Yes/No field with this option group? I did it with
a check box but think it will look better with an option group.

I'm really not sure what you want here... filters are created on values in
fields in queries, not on controls. A boolean (yes/no) field can only hold
one of two values, not three.

Best of luck


Tim F

 

[doyle60]

The answer to your question is in the names I chose for the three
options: Checked, Unchecked, and All. In other words, there are three
situations with a Yes/No field as far as my option group on my form is
concerned: give me only checked, give me only unchecked, and give me
all.

As I said, I got it to work by creating a field called "ShowMe" and
with a rather complicated nested IIf statement that returns either
"Show" or "NoShow". Than I filtered the same field with the word
"Show".

It works, but I could learn a better more elegant way for my files.

Thanks,

Matt

 

[Bas Cost Budde]

I have a query with a Yes/No field. On a form I have an option group

with these Names and Option Values:

Checked: 1
Unchecked: 2
All: 3

The Option Group is Frame15, if that comes into play.

How do I filter the Yes/No field with this option group? I did it with
a check box but think it will look better with an option group.

I'd say:
choose(frame15,field=true,field=false,true)