Suppress Access Error Msgs

[legendv]

How do you suppress Microsoft Access error messages?
For instance, when user enters date format incorrectly I would like my own msgbox to appear instead of access. But I don't know how to suppress MS A2K's error msg.

Any suggestions?

Thanks

 

[nealvenables]

To trap errors...

private sub MyProc()

on error goto ErrHandler:

<Code that could raise errors here>

exit sub

ErrHandler:

msgbox &quot;Access is handling this error!&quot;
on error goto 0

End Sub

Alternatively, to supress warnings (e.g. &quot;You are about to run a query that will update 100 rows&quot

docmd.setwarning false

 

[legendv]

Nealv,

Thanks