Adding to combo box

[NISMOJim]

What is the best way for a user to add a name to a combo box list? I have a combo box on an inventory form that has a row source from the manufacturers table. Occasionally a part will come in from a manufacturer that is not in the dropdown list. Is there a way for the users to just type the name in the box, adding it to the table so it will show up in the dropdown list the next time it is needed? There are only 2 users that add inventory to the tables, so I don't mind them being able to add names, but I would prefer they not have to physically go into the table to do it.


Thank you for your help, and I'm saving my most complicated question for last!

[RuralGuy]

Set Limit to List to YES and open the next form in the NotInList event.

[NISMOJim]

Funny thing, I searched for this last night and found nothing that quite related to what I needed. Today I was searching threads for something completely different when I found the link to "Not In List". I did some tweaking with the 3 examples I found, and almost dropped dead when it worked on only the 3rd try.
You Guys Rock! Wouldn't be where I am withoutcha!

[RuralGuy]

Great! Are you ready to use the Thread Tools and mark this thread as Solved?