>>Hi,
>>
>>Just doing a Requery() is apparently not enough. Can you elaborate on some details? Specifically:
>>
>>
What would you use for the ComboBox.RowSource and ComboBox.RowSourceType?
>
>I use something like 'csrClients' for the RowSource and RowSourceType is an alias (2 I think)
>
>>What do you mean with "unbind and bind it again" - does this refer to blanking properties RowSource and RowSourceType?
>
>Yes, I set them to blank when I need to re-build, create the cursor and then set them back again.
>
>>Do I understand that I just load the cursor in Form.Init(), and then re-load when I add a new client in the other form?
>>
>>Thanks,
>>
>>Hilmar.
>
>Yes, that's how I would do this. If you set cursor as a property in the property sheet, then you need to build the cursor in form's Load, not Init.
I feel sort of stupid now. I just noticed that the RowSource was based on a view, not the original table, so of course the data wasn't updated until I did a requery(). The problem was not with the ComboBox after all, but with this view.
Thanks for your help, it certainly helped me clarify my thoughts!
Difference in opinions hath cost many millions of lives: for instance, whether flesh be bread, or bread be flesh; whether whistling be a vice or a virtue; whether it be better to kiss a post, or throw it into the fire... (from Gulliver's Travels)
