removing message boxes

[Guest]

I have created a macro for OnNotInList which includes my own messagebox.
However, the standard message box still appears after mine; how do I remove
it?

 

[Guest]

I have created a macro for OnNotInList which includes my own messagebox.
However, the standard message box still appears after mine; how do I remove
it?

Have you already tried the SetWarnings command?

 

[fredg]

I have created a macro for OnNotInList which includes my own messagebox.
However, the standard message box still appears after mine; how do I remove
it?

Code is easier.
Use:
Response = acDataErrContinue

If MsgBox("Your message here.",vbYesNo) = vbNo Then
Response = acDataErrContinue
End If

 

[Guest]

No. How and where do I do that?

Have you already tried the SetWarnings command?

 

[Guest]

Tim, I worked it out and used it but it had no effect - perhaps because it is
an error message - "The text is not in the list. Choose from the list"?

 

[Guest]

Aileen, sorry that the SetWarnings didn't work.

In this case, and after testing a little myself, I'm going to have to agree
with Fred on this one.