I have a drop down combo box that holds the fifty states, and it works fine. When I navigate through my recordset, it displays the correct state that was selected for that record.
However, every time I navigate through the recordset, im reloading the combo box and setting the listindex equal to the current record (state.itemdata(state.listindex). This seems kind of cumbersome that you have to do it this way, but this was a suggestion from another expert.
Is there any other solution? Maybe a DBCombo? What is your suggestion.
Im loading the listbox with a recordset using oledb and a do while loop. (VB6 + SQL7.0)