>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.


Hilmar,

I suppose the class made by Mike Gagnon (accombo) will give you the functionality you are looking for, please look for Message ID97709 in Foxite forum.

Mike's accombo combo box class will permit you to do the filtering you request and if you like also allow endusers to add new values to the combo-list.

Regards,

Koen