I have a vendor table with ID as the auto generated primary key, followed by Vendor Name and Addr, etc... I created a form with a search field up at the top so that if you type in a vendor name and if it is in the list it will show up in the auto search and when you press enter or tab it will go to that specific vendor record. If you enter a name that is not in the list, I would like it to ask me if I want to add it as a new vendor. Can you help me with the coding for the "Not On List" command? Thanks!

Look up "Solutions" not in list.
HTH