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


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