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