Which SUB is calling this SUB

Question

Does anyone out there know how to do a stack trace in access-vba. I'm trying to do something like:

Public Sub a()   
    Call c    
End Sub    

Public Sub b()    
    Call c    
End Sub

Public Sub c()    
    Debug.Print "Which sub has called me ?"    
End Sub

What I want to do in Sub c is to show if that has been called by Sub a or Sub b without passing any arguments. In c I would simply show the stack but I have no idea if this is even possible in VBA - any thoughts ?

Answer 1

You can use Mztools Addins which has an option to view the procedure caller. Download Mztools