Option Group

[huskies]

Is there a way to filter specific data by my option group? So here is what I am doing.. I have ages of people I want split out by..

<18
18-50
50+

.. I have created my option group with those 3 values.. How can I tie this to the query I am running to filter it when I select one of those values? Thanks in advance for your help!

[SoftwareMatters]

In your query on the column that has ages you need to add reference to the option group. It will be something like this:

[Forms]![FORM NAME]![OPTION NAME]

[huskies]

do I have to include this whole thing...

[Forms]![FORM NAME]![OPTION NAME] Or [Forms]![FORM NAME]![OPTION NAME] Is Null

Or just the string you put together?

Thanks again

[SoftwareMatters]

If you want the query to show everything if it is blank it becomes more complicated. You need to add a new column to your query and in the field type the following (it needs to be edited with correct form/field names):

IIf(IsNull([Forms]![FORM NAME]![OPTION NAME]),([AGE FIELD NAME]) Like "*" Or ([AGE FIELD NAME]) Is Null,([AGE FIELD NAME])=[Forms]![FORM NAME]![OPTION NAME])

In the criteria for this new field type <> false

[huskies]

I see, so in this example you have one option name.. but I have a different option name for each option box I have.. how do I incorporate all 3 selections into the query? (M,F,Both and then same for age)

[SoftwareMatters]

The option group should have 1 name

[huskies]

got ya, which is probably the FrameName.. something like that. Thank you, will try in a bit and let you know how it turns out!

[huskies]

And you have 3 different "age field names".. Are these the 3 different names of the check boxes in the option group?

[huskies]

Ok, so that worked.. However in the query it is returning a result of -1,-2,-3 in that new field and not returning all the people with the ages of <18, etc.. What do I need to change in the option group to pull in only those individuals?

[huskies]

so,, in other words.. How do I set the option value for one of my check boxes =<18 instead of = 1? Is there a way to insert a data range?