Can I get the name of the procedure that an error has occurred in?For example, I would like to send my error to a form that containsthe error number, the description, form name and the procedure name(like load_form, Next_rec, etc….) I am currently using err.description,err, and err.source for the project name. Now I need the procedure namethat the error occurred in.
At the last VBITS, the guys from Microsoft said that they were planning to put this functionality into the next version. In the meantime, I would create a global variable that is set within each procedure to the procedure name. This way, when an error pops, you have the information you supplied to yourself. Since you’re using a local error handler already, you can just pass the procedure name. However, the short answer is that no, you can’t get the procedure name.