>>Can you move the re-creating method to a separate method of the form and unbind the combo before re-creating the cursor? E.g.
>>
>>combo.RowSource=''
>>recreate the cursor
>>combo.RowSource = 'myCursor'
>
>In fact, the cursor is never recreated. The only place Requery is called is in the Init method. And when the form first opens, the combo shows the right value.
>
>Tamar
Tamar,
I see, but I would still suggest to use a different method, not combo's method. In form's Init call a method to set combo's properties. Leave RowSource blank in the properties sheet.
This way you would be sure it's not contributing to the problem.
If it's not broken, fix it until it is.
My Blog