Dan Waters
dwaters at usinternet.com
Wed Aug 2 12:07:16 CDT 2006
Well, I typically have Error Trapping set to 'Break on all Unhandled Errors'. I'll change to 'Break in Class Module' to see if that does the trick. Thanks! Dan -----Original Message----- Subject: Re: [AccessD] [SPAM SUSPECT] Error Trapping There can be a couple of issues here. One is as stated, if you have "On Error Resume Next" active when you invoke a sub or function then errors in the lower level routine will kick back to the upper level. The other issue is that if you invoke a method in a class module, even without On Error active, what happens depends on the setting Error Trapping option in VBA. If Error Trapping is not set to "Break in Class Module" then the error will be trapped in the routine that invoked the method. Regards, Steve