I have a combobox that gets its info from a query that is based on a table (I am using the query to ensure that the info in the combobox is in alphabetical order)

When a user selects a name from the combobox list, the name is stored in the table.

I need the combobox to be able to accept having a new name entered into the list and then update the list to reflect this change without having to close down/reopen the form to update the query.

Can this be done(easily)?

Thanks in advance for any help

This article will show you how to use the NotInList event of a Combo box to do what you want.....
http://support.microsoft.com/support/kb/articles/Q161/0/07.asp?LN=EN-US&SD=gn&FR=0

Thanks for the link. http://pages.hotbot.com/advice/lucker/images/bouncing.gif