How can I suppress "paste errors" message?

[MushMouse]

When my user tries to paste incorrect data into a form,I get 2 messages. The 1st, I've been able to suppress & replace with my own message. The 2nd, "records that... was unable to paste have been inserted into a new table called paste errors". I know that it is error # 8511, but I can't figure out where it's happening so I can suppress it. Any adive would be most appreciated!! Thanks!

 

[PHV]

Have you tried with the DoCmd.setWarnings method ?

Hope This Helps, PH.
Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884 or FAQ181-2886

 

[MushMouse]

Yes - it's set to false, but I'm still getting the message...

 

[PHV]

And what about the Error event procedure of the form ?

Hope This Helps, PH.
Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884 or FAQ181-2886

 

[MushMouse]

I was able to trap the 1st error message (2113) through the error event in the form. Somehow, it doesn't seem to trap the 2nd 1 (8511). I identified the # by looking up the message I was getting in a list of Access/Jet error messages.

 

[MushMouse]

Oops! I rechecked the setwarnings & it was set in the wrong place! Now it's working!
Thank you so much for your help!