Filter Combo list by Option Group item selected.

[Clousejd]

Using MS Access 2007 - I have a form to input records. I have an Option Group in a Frame and a Combo List where the row source comes from a table query (Select All).
I want to filter the row source in the Combo List depending on what Option Item I select in the Option Group. How do I know what Option Item I have selected on the form before I have saved the record? If I have that value, I can modify the Select for the Combo List row source to select only those records that are of type 'OptionValue'.


Thank you in advance...

[pbaldy]

You can use the method here that changes the row source of the combo:

Baldy-Cascading Combos

You test the value of the frame to get the selected value of the option group. Typically it's a number 1, 2, 3 etc, though you can set it to other things.