How do you capture the function name to use in an error routine

[Pack10]

I have an error routine that writes error messages to a table. I would like to capture the function where an error happened. How would I capture the function name.

 

[dhookom]

I believe you would need to send the function name into your "routine that writes error messages". Allen Browne has a solution at Error Handling in VBA.

There is some additional information at FMS web site

Duane
Hook'D on Access
MS Access MVP

 

[Pack10]

Thank you -- thats perfect.