>>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?
>
>Set both RowSourceType to 6 - Fields
Set both as you suggested to 6 - Fields (checked to make sure it was changed after test)
Thanks for the try but nothing changed.
Beer is proof that God loves man, and wants him to be happy. - Benjamin Franklin
John J. Henn