>Hi,
>
>A ComboBox lists entries from a related table ("Clients" in this case). In a different form, a new client is added. The new client should be selected in the first form. I managed to get the correct client selected - but it doesn't display correctly, until I exit the form and run it again. The ComboBox somehow isn't aware of the new record.
>
>The ComboBox properties are:
>RowSource = "Client.Name, City, ..."
>RowSourceType = 6 - Fields
>
>How can I force the ComboBox to refresh? Should I use a query instead of a list of fields instead; or what would the best strategy be?
>
>TIA,
>
>Hilmar.
I always prefer to use a cursor for the RowSource and in this situation rebuild it and then requery the combo (unbind it and bind again).
For your case you may just try to requery the combo, it may be enough.
If it's not broken, fix it until it is.
My Blog