locked
Filter Combo list by Option Group item selected. RRS feed

  • Question

  • 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...

    DanC


    JD Clouse
    Tuesday, November 23, 2010 5:18 PM

Answers