Multiple Option Group Filters

I have a database that contains a list of schools across multiple STATES. I
have an additional location field that contains "Northern", "Central" and
"Southern"; to define the REGION within the state for each school.

1) I built an option group (radio buttons) powered by a macro (ApplyFilter)
that lets the user select the STATE: NY, NJ or CT. This works well.
2) I built an second option group (radio buttons) powered by a macro
(ApplyFilter) that lets the user select the REGION: Northern, Central or
Southern. This works well.

The problem is that I want both of the above to work in tandem. Above only
applies one filter at a time; for example - I would like to select NJ from
item 1 above and see all schools in NJ, THEN select Southern from item 2 and
see all schools in Southern NJ.

Ultimately, I would like to have a half-dozen option groups each drilling
down the master list into deeper subsets. HELP.

....never mind...I figured it out...all is working well.

"DavidSt" wrote:

I have a database that contains a list of schools across multiple STATES. I
have an additional location field that contains "Northern", "Central" and
"Southern"; to define the REGION within the state for each school.

1) I built an option group (radio buttons) powered by a macro (ApplyFilter)
that lets the user select the STATE: NY, NJ or CT. This works well.
2) I built an second option group (radio buttons) powered by a macro
(ApplyFilter) that lets the user select the REGION: Northern, Central or
Southern. This works well.

The problem is that I want both of the above to work in tandem. Above only
applies one filter at a time; for example - I would like to select NJ from
item 1 above and see all schools in NJ, THEN select Southern from item 2 and
see all schools in Southern NJ.

Ultimately, I would like to have a half-dozen option groups each drilling
down the master list into deeper subsets. HELP.