Access2003 - Turn off NotinList error msg

Posted on 2007-07-30
Medium Priority
Last Modified: 2007-08-23
Can't turn OFF MS Access 2003 Error Messages... I'm using DoCmd.SetWarnings False on NotinList action.  Still getting msg: "The text you entered isn't in the list".  I KNOW that.  I am directing the user to a form that allows ADDING a record to the drop down list.  Making me c-r-a-z-y.  Help?
Question by:wintactics
LVL 48

Accepted Solution

jpaulino earned 250 total points
ID: 19598255
If you have a dropdownlist populated from a table you must choose a field from the list (if it's bound). You can choose the on the events - not in list and add the code Response = 0.
LVL 13

Expert Comment

ID: 19599423
Can you publish the code

Author Comment

ID: 19601900
Thanks.... found the answer on my own (google).  

Featured Post

Concerto's Cloud Advisory Services

Want to avoid the missteps to gaining all the benefits of the cloud? Learn more about the different assessment options from our Cloud Advisory team.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

In Part II of this series, I will discuss how to identify all open instances of Excel and enumerate the workbooks, spreadsheets, and named ranges within each of those instances.
We live in a world of interfaces like the one in the title picture. VBA also allows to use interfaces which offers a lot of possibilities. This article describes how to use interfaces in VBA and how to work around their bugs.
In Microsoft Access, learn different ways of passing a string value within a string argument. Also learn what a “Type Mis-match” error is about.
Access reports are powerful and flexible. Learn how to create a query and then a grouped report using the wizard. Modify the report design after the wizard is done to make it look better. There will be another video to explain how to put the final p…
Suggested Courses
Course of the Month14 days, 18 hours left to enroll

839 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question