>>I have a form with 2 combo boxes set as follows:
>>Cmb 1:
>>RowSource = c_cursor.fldname
>>RowSourceType = 2 - Alias
>>ControlSource = Thisform.startname
>>
>>Cmb 2:
>>RowSource = c_cursor.address
>>RowSourceType = 2 - Alias
>>ControlSource = Thisform.startaddr
>>
>>The InteractiveChange Event for both call a method that gets the keys from each cursor and looks up a record in another table. All this works till the form refresh() is called in the lookup method. The both combo boxes revert back to the 1st record in each cursor.
>>
>>If I comment out the refresh() it works.
>>What's up?
>
>
>check out
http://www.jamesbooth.com/eventorder.htm the section with "Updating data."
Thanks everyone for the input. I found the reason. The interactive change was running before the values got set in the RowSource. The Refresh() then set the combo boxes back to the value of the RowSource. All I had to do was set the RowSource = ComboBox.Value at the top of the lookup rtn and all is well.
Beer is proof that God loves man, and wants him to be happy. - Benjamin Franklin
John J. Henn