Is this Combo binded to a filed of a table?
>>>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?
>>>
>>>Thanks,
>>>Elyse
>>
>>try:
>>
>>Combobox::Refresh
>>
>
>I had that in there, too. Didn't help.
Against Stupidity the Gods themselves Contend in Vain - Johann Christoph Friedrich von Schiller
The only thing normal about database guys is their tables.