I've backed myself into a project written in Access/VB and have found it to be fairly easy to pick up. However, there is no error-trapping routine in the application so the users are simply given an error box with debug as an option!

I would like to add a generic error-trapping routine to the app (like Foxpro's "on error") to save vital info to a table such as error number, message, procedure, lineno, etc.

Does anyone have a simple routine they would be willing to share? I'm not even sure how to implement, so a sample call or dim statement would be appreciated as well.

Thanks in advance.