>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
Against Stupidity the Gods themselves Contend in Vain - Johann Christoph Friedrich von Schiller
The only thing normal about database guys is their tables.