Is it possible to obtain the name of the sub or function that is executing
to be displayed in a message box when an error occurs

For instance:
If  Form_Load() caused the error the messagebox should show the error
number(err.number) , description (err.description) and the function
name(Form_Load) aswell.
the  err.source property only returns the name of the project, which is not
quite what i am looking for

Thanks
Nicolaas

Go to tool/option/general......Error trapping......set to Break  on Unhandled
Error.

then run it.

hope this helps
regards,
afraz

Sub Form_Load()
Const PROC = "Form_Load"

    On Error Goto ErrorHandler
...
Exit Sub
ErrorHandler Err.Raise Err.Number, PROC, "Doh!"
End Sub

(this is not meant to illustrate good error reporting!)
--
RobSmith

: Is it possible to obtain the name of the sub or function that is executing
: to be displayed in a message box when an error occurs