I think in your complex and tricky situation is better to use array as the source for your combobox. Grab the data from the table into the array. Have your combo unbound and update your table manually in lostfocus event of the combo (or valid).
>Yep, I am doing it.
>WITH .cboDefects
> .ControlSource = ''
>ENDWITH
>
>
>>>>>And here is an error I am getting:
>>>>>Alias 'CURITEMDATA' is not found. frmseconds.cbodefects.ControlSource 0
>>>>>If it's not found then how come it did not fail in any line above the erroring line?
>>>>>
>>>>>Thanks for help.
>>>>
>>>>Did you close the cursor somewhere after this code?
>>>
>>>No, but I am switching data sessions though. Strange thing is that sometimes it fails, sometime not.
>>
>>Try to unbind your combobox before switching DS.
If it's not broken, fix it until it is.
My Blog