Is there any properties that states the currently called function/subroutine
name ?

e.g.

Sub abc()
    debug.print Me.Name
End Sub

I know there is no Me in a Standard Module. Is there any way ? Please help.

Thanx in advance.

Hi,

Not that I'm aware of.  You'll need to define a string that carries the sub
name and change it from each sub.

HTH
--
Just my $.001
Please limit questions to newsgroups only!
Dev Ashish
---------------
The Access Web ( http://home.att.net/~dashish )
---------------

:Is there any properties that states the currently called
function/subroutine
:name ?
:
:e.g.
:
:Sub abc()
:    debug.print Me.Name
:End Sub
:
:I know there is no Me in a Standard Module. Is there any way ? Please help.
:
:Thanx in advance.
:
:

-- Jim Ferguson, FMS
   http://www.fmsinc.com