shared subform

[Guest]

Hello. I have a subform that is used by form X and form Z. I need something
such like, if the form is openned from form Z then action 1 elseif openned
from form X then action1

Is it possible?

Best Regards,
Marco

 

[Guest]

Yes, use the fIsLoaded function from this link

http://www.mvps.org/access/forms/frm0002.htm

Then, in your code you can use it to check which form is open

If fIsLoaded("FormName") Then
Action
Else
If fIsLoaded("Form2Name") Then
Action
End If
End If

 

[Mr. B]

Hello. I have a subform that is used by form X and form Z. I need something
such like, if the form is openned from form Z then action 1 elseif openned
from form X then action1

Is it possible?

Best Regards,
Marco

Marco,

Yes, you can use different code in the On Open event of your form X
and/or your form Z to take the necessary actions with the subform as
are needed.

Hope this helps.

Mr. B