Determine the name of the caller of a procedure

[Thinh]

is there a way to be able to determine who the caller of the procedure. on form you have parent but in vba i dont know how to determine the caller of a procedure.

This is what i want to accomplish

Private sub test
call Two()
end sub

Private sub two
me.parent.rowsource = ""
end sub

i know i can pass the name of the control as string to the second procedure but i want it to make it as easy as possible. From programmatic standpoint you should be able to determine who the caller is. the same concenpt as callerid, because the first function is still alive when it calls the second function so it is still in memory .

anyone know how to solve this problem.

thanks in advance

 

[namliam]

As far as I know there is not a way to do what you want other than using the "passing of variables" you allready suggested.