Combo box the fills itself as you go

[Guest]

Hi, I am relatively new to access and have a little VB knowledge. I am trying
to make a Combo box that as I type in information into the field it will
continually add new entries to my list. Trying to make it a little easier to
enter my info into a form. I've been messing around with sample project
before I add it into the project that I want to add it to. My sample project
is a CD list. I'm trying to make a combo box that has the Genre (jazz, rock,
etc) of the CD's that I am adding to the list. The field is Labeled Genre.
Any help will be Greatly appreciated.

 

[Guest]

You can do this by setting the LimitToList property to Yes and using the
NotInList event and a little code.

Take a look at

http://msdn2.microsoft.com/en-us/library/Aa211431(office.11).aspx
http://www.blueclaw-db.com/access_notinlist_advanced_example.htm

if you google notinlist event you'll get tons of info