I'm now trying to add error handling to every procedure as suggested elsewhere on the internet... however when I use "On Error GoTo PROC_ERR" at the beginning of the procedure right after the variables are declared --- the error handler ALWAYS gets invoked because VBA always gives me Err.Number = 0, and therefore always bypasses my code to go straight to the error handler. What is the point of using On Error in a procedure if it is always going to trigger based upon an Access no error Err.Number of 0?
It seems a waste of processor instructions to always go straight to the error handler with an On Error that always gets triggered and then try to engineer a way back to the code that you actually want to run.
What am I missing?