Combo Box and NotInList

[Barb St. Clair]

If anyone could offer assistance, I would be grateful. I am trying to
find code to direct any NewData entered in a combo box will be compared to
the table associated with the form and if the NewData does not exist in
the
table, add the NewData to the table and update. The code I have found
isn't
working under NonInList. Any suggestions?--

 

[Graham R Seach]

Barb,

Try this:
http://www.pacificdb.com.au/MVP/Code/NIL.htm

Regards,
Graham R Seach
Microsoft Access MVP
Sydney, Australia

 

[Roger Carlson]

On my website (see sig below) are two sample databases: NotInList and
NotInListAlternatives, which show a variety of ways to do this.