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?
Beer is proof that God loves man, and wants him to be happy. - Benjamin Franklin
John J. Henn