Prev: Transparent image dragging
Next: formattting numbers
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 news:%23UWhY6m2KHA.4332(a)TK2MSFTNGP02.phx.gbl... > > "Phil Hunt" <aaa(a)aaa.com> wrote >> When formX do a formY.Show vbModeless, Me, does formY know the reference >> of >> 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 > Form) > If Not IsMissing(Owner) Then > Set mOwner = Owner > Me.Show Style, Owner > Else > Set mOwner = Me > Me.Show Style > End If > End Sub > > > Where mOwner is a form level variable you can use to show the calling > form. > > Then instead of using: FormY.Show vbModeless, Me > Use: FormY.ShowForm vbModeless, Me > > HTH > LFS > > |