Dan Waters
dwaters at usinternet.com
Wed Aug 2 12:07:16 CDT 2006
I do always use explicit variables to avoid just that type of 'mystery' problem. The error handler is a different procedure which has always been reliable. It's just an issue of which procedure calls it! Thanks! Dan -----Original Message----- Subject: Re: [AccessD] [SPAM SUSPECT] Error Trapping Either the error is in the handler or after the handler or you may have a different problem. I've seen code fail on the End Sub line and eventually discovered something elsewhere in the module that wasn't even in the routine that used an implicit boolean or such and fixing that made the problem go away. Charlotte Foust