I need to come up with a proper (best) way to catch error in my access 2007 application. I have created an error table and plan on insert error code and descriptions in the table instead of showing it as a message box. How should I go about this? Should I create one function that inserts the error into the error table, then from my other functions is where I call the error function?
My error table is
CallingProc (function) TEXT