Current Function

[Turner]

I have a standardized error handler that is used in each
of my user functions. All the parameters with the
exception of the Function Name are variables. Is there
any EASY way of determining the current function?

I am currently using Access 97!

Private Sub Form_Open(Cancel As Integer)
On Error GoTo err_Form_Open

Call PopulateGobalVariables
Call VerifyDbAvailability
Call OpenPassWordForm
DoCmd.Close acForm, Me.Name

exit_Form_Open:
Exit Function

err_Form_Open:
' I would like Form_Open to be a variable!!
Call MyErrorHandler(Me.Name, "Form_Open",
Err.Description, Err.number, gblstMessageResponse)
Resume exit_PopulateGobalVariables

End Sub

 

[Douglas J. Steele]

Nope. What you're doing (or some variation thereof, such as setting a
variable at the beginning of each routine) is the only way.