>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?
Do you change thisform.StartName and thisform.StartAddr values in the InteractiveChange ?
If it's not broken, fix it until it is.
My Blog