From: Phil Hunt on 12 Apr 2010 16:10
Thanks. I think it is similar to what Bob said. Very helpful. I think I use
them instead of api.
"Larry Serflaten" <serflaten(a)usinternet.com> wrote in message
> "Phil Hunt" <aaa(a)aaa.com> wrote
>> When formX do a formY.Show vbModeless, Me, does formY know the reference
>> Me (where it originate).
>> I am trying to show the original form and I don't want to use vbModel. If
>> not, any sugestion is welcome.
> I'm not sure if this will suit your needs, but you could give FormY a new
> ShowForm routine that allows you to pass in a reference:
> '[ In FormY ]
> Public Sub ShowForm(ByVal Style As FormShowConstants, Optional Owner As
> If Not IsMissing(Owner) Then
> Set mOwner = Owner
> Me.Show Style, Owner
> Set mOwner = Me
> Me.Show Style
> End If
> End Sub
> Where mOwner is a form level variable you can use to show the calling
> Then instead of using: FormY.Show vbModeless, Me
> Use: FormY.ShowForm vbModeless, Me