Trap "Who Called Me" 2

[edbloom]

How do I trap "Who called me?" It will be a form via the On_Click event. The procedure will be available from at least three different form depending on the work flow already built into the database. I am just adding a new funnction that is varied only slightly based on "Who Called Me."

Thanks, Ed

 

[Remou]

You can use OpenArgs to pass the name of the calling form.

 

[jebry]

Hi!

If you are using VBA to call the form then you can use the following:

DoCmd.OpenForm "YourForm", , , , , , Me.Name

Then, in the form that you have called you use Me.OpenArgs to get the calling form's name.

hth


Jeff Bridgham
Purdue University
Graduate School
Data Analyst

 

[edbloom]

My bad. I failed to properly word my question.

The trap needs to be in the module. So when the procedure/function is called in the form.btnOn_Click event, I can trap and know which form the call came from.
is it frmA, frmB or frmC?

Sorry for the confusion.

 

[jebry]

Hi!

In your module you can use:

Dim frm As Form

Set frm = Screen.ActiveForm

Then you can get the name using frm.Name

hth


Jeff Bridgham
Purdue University
Graduate School
Data Analyst

 

[MajP]

public sub codeBeingCalled(strFrmName as string)
your code
end sub

from any form

private cmdBtn_Click()
call codeBeingCalled(me.name)
end sub