>I have a combobox (#1) where I choose a value from its drop-down list. Then, that value is used in a SELECT SQL statement to build the combobox (#2s)drop-down list. I can successfully choose a value in both comboboxes and save the value. That all works.
>
>But The problem I am having is that if I go back to combobox (#1) and choose a different value or even the same value from combobox (#1s) drop-down list, it's as if the combobox #2 drop-down list is no longer showing the correct number of drop-down items. It only seems to show the correct number of items the first time I do the SELECT SQL in combobox #1 to populate combobox #2.
>
>It's as if the combobox (#2) needs to be reset before the combobox (#1) SELECT SQL runs again, or I don't get what I want in the combobox (#2) drop-down list.
>
>What would be the best way to reset combobox (#2) so it always shows the proper result from the combobox (#1) chosen value?
>
>I hope I didn't confuse you.

OOPS -- sorry, that's RowSource for a ComboBox, not RecordSource. My bad.