>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."
Charles
"The code knows no master." - Chuck Mautz
"Everybody is ignorant, only on different subjects." - Will Rogers