Updating linked table after adding new record

[John Wadsworth]

I have a database for entering information for clients. I
have a drop down field populated by a linked table in a
separate database. If the client is not in the drop down
list I am prompted that the person is not in the list, do
I want to add them. I click yes and add them to the
linked table.

My problem is that following adding them to the list,
they don't show up in the alphabetically sorted list but
are at the end of the list. This then prevents them from
showing up by starting to type in their name.

Any suggestions please!!!!!!!! I need help.

 

[Van T. Dinh]

Set the RowSource of the ComboBox to a Query with the ORDER BY clause so
that the names are sorted. I assume (from your post) that you already
requeried the ComboBox after you added the Client.