Allow New Entries in a Combo Box

[MichaelA]

I'm sorry if this has been asked already, I can't seem to find what I'm looking for.

I have a combo box that shows a list from a table. I want to be able to type a new value into the combo box, if the value doesn't already exist and have the new value be stored to the table. Is this possible?

Thank you, in advance,
Michael

[pbaldy]

Search here on "notinlist", which should turn up the 2 basic methods of using the Not In List event of a combo to add values to the source table.

[MichaelA]

Thank you, very much!

[pbaldy]

No problem, post back if you get stuck.