Add Value to Combo Box

[mickeync]

Hi,
I have a drop down box name "Company Name". The Company Name is only a field from a table. I need to make this drop down box eligibility to add NEW COMPANY NAME automatically when the user can't find the matching COMPANY NAME from the drop down box. I am using Access 97.

I really appreciate any help!!!

 

[WildHare]

Do a search through the FAQs here for the NotInList event. It's what you want to use to allow a new entry into the source for a combo box.

Me? Ambivalent? Well, yes and no....
Another free Access forum:

http://www.forumco.com/jmhare

More Access stuff at

http://www.jmhare.com/wildhare2.htm