Msg the Current Sub or Function the code is in

[Max1mum2]

Is it possible to define what sub or function was being executed at the time of an error?


- maximum

 

[psemianonymous]

Depends. If you're running internal VBA code, you should get a dialog box which prompts you for "Debug / End / something else i can't remember". Click on Debug and it will go EXACTLY to the line where it failed. --
Find common answers using Google Groups:

http://groups.google.com/groups?group=comp.databases.ms-access

 

[MikeLoon]

You can also set cues on the status bar as each sub or function starts

 

[Max1mum2]

Ah the word cues brought an idea into my head. I will just define the Sub or Function name in a string at the beginning of that sub/function then if a error occurs I can just call my error handler that writes the error to the table, but now i can add the sub/function name!. thanks a lot

- Maximum