Procedure_Event Name Property?

J

JohnWL

Is there any property or constant or something I can read in VBA to get the
complete name of the current procedure in a form's module
(txtFwdCity_AfterUpdate in example below)? And the module name (frmLeaseEdit
for the example below)? It would sure simplify error handling code, such
as:

Sub txtFwdCity_AfterUpdate()
On Error GoTo HandleErr
My code
HandleErr:
' FormName = Me.Form.Name or something
' ProcName = Me. Proc.Name or something
Call LogError(Err.Number, Err.Description, FormName, ProcName)
End Sub
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top