How do you keep the error message f 1

[MikeLoon]

How do you keep the error message from appearing when the "Not in List" event fires. I am handling the error and I know there is a trick to it but I can't find it.

 

[tlbroadbent]

Add "Docmd.SetWarnings False" to your code. Set warnings True when the process finishes. If you want to get the best answer for your question read faq183-874.

Terry L. Broadbent - DBA
SQL Server Page:

http://tlbroadbent.home.attbi.com/sql/sql_articles.htm

 

[annsolomon]

Check out the acDataErrAdded constant. Ann

 

[MikeLoon]

Thanks Ann that was the trick I couldn't remember.