Need my combobox to accept new data (not in list) and update the list. ???

[SomeGuy]

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

 

[Jack Cowley]

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

 

[SomeGuy]

Thanks for the link.