I have 3 combo boxes within my form. The first combo is populated right away. Within my second combo the datasource query I have it pointing to the previous combo box like this [Forms]![frmLoad]![subChild]![frmStart].[Form]![frmEnd]![cmb1]. The query brings back an ID and text. The text is displayed and the id is the value. What is happening is if I change the first drop down on record 1 it is changing the text for combo2 on record2. Unless I click on that record then it seems to show me the right text.



Is there something with Continuous forms that has to be setup to not allow this to happen?


Thank You