how do i write an event property for "Not in List"

[NoviceUser]

On a form all I want to do is add an item automatically to a table if it does
not exist in a combo box.
What should I write in the Code Builder to I achieve this?
Where do I put the event on the form property sheet?
Im an absolute novice on access but this should be so simple for Gods sake.
HELP.

 

[Lars Brownies]

Have a look at http://allenbrowne.com/ser-27-01.html which is a detailed
explaination of what you're looking for.

Good luck.

Lars

 

[Arvin Meyer [MVP]]

I have generic code which will work with any combo box at:

http://www.datastrat.com/Code/NotInListCode.txt

there is a demo of how it works at:

http://www.accessmvp.com/Arvin/NotInListDemo.zip