Error Handling

[XLEAccessGuru]

Hi all,


I don't know why my app gets zero errors, but to handle them, I need to resume the procedure in which the error occurred when the error message equals "0". It's not happening. When some of my users double-click the list box to run the selected query, it nothing happens. I was able to identify that the "zero" error is occurring.

Can anyone tell me how to resume the event procedure that produces the"zero" error? I've tried resume, resume next and a couple others and they aren't working. How can I just get the code to skip the error handler and resume the code execution when the error message is zero?

Any help would be vastly appreciated!

 

[boblarson]

You need to put an "Exit Sub" just before the Error handler otherwise the code continues on through the error handler and if there isn't an error the error number is zero (0).

 

[Cosmos75]

Here's a link to an article on VBA Error Handling and Logging, which also has some links at the end of it.