Get Rid of Default Error Messages

[DanaPach]

I have written an event procedure for 'On Not In List' for a Combo Box - to bring up an error message that I wrote. However, once they click ok on my error message, Access brings up it's own error message right after mine. How can I stop it from doing this?? Any help would be greatly appreciate. I have set the docmd.setwarning to False already and it is not preventing the access error message.

 

[RoyVidar]

Hi!

Put the line:

[tt]Response=acDataErrContinue[/tt]

within your not in list code.

Roy-Vidar

 

[TheAceMan1]

How are ya DanaPach . . . . .

Here's the full context of using the [blue]Response[/blue] variable with messagebox:

[blue]If MsgBox("Add To List?") =vbYes then
   'Your Code To Add To List
   [purple]Response[/purple]=acDataErrAdded
Else
   'Return to ComboBox
   [purple]Response[/purple]=acDataErrContinue
End If[/blue]

See Ya! . . . . . .

 

[DanaPach]

Thank you for your help on this. The acDataErrContinue worked great.
Thanks again

 

[DanaPach]

Thank you for your help. It worked great. I appricate your response.