Elyse,

You need to call the Requery() method of the second cbo so that it'll reconstruct the droplist.

>I have a combobox (RowSourceType=3-SQL Statement, Style=2-Dropdown List) whose RowSource changes based on the value of another field. For example, if the other field's value is "A", the values for the dropdown are "A","B", and "C". If the other field's value is "B", the values for the dropdown are "1","2", and "3". When the value of the other field changes, I reassign the RowSource of the combo to a new SQL Statement. But the combobox "remembers" the previous position, i.e. if the value was "2" and I change the RowSource, the value will appear as "B", the second item in the list. I've tried setting the Value and DisplayValue to "" and the ListIndex to 1 (the first element is always "") after resetting the RowSource, but when I click on the combo it still remembers its previous position. Any ideas?