reference textbox of subform in VBA

[luanhoxung]

Hi all !!
i have met trouble with referring textbox of subform in VBA
i know i can do as: forms!mainform. subform.textbox
but i want do it in shorter path.
any suggestion about using variable ?
Pls help me !!
many with thanks !

[Larry Linson]

"luanhoxung " <lu********@yah oo.comwrote

i have met trouble with referring textbox
of subform in VBA
i know i can do as: forms!mainform. subform.textbox
but i want do it in shorter path.
any suggestion about using variable ?

If the VBA is in the module of the main form, you can use the "Me" notation
for currently-active form, as

Me!SubformContr olName.Form.Tex tBox

I would NOT expect the format you show to work, but that might depend on
what you mean by "subform", as there is no "Subform" object in Access --
there is a Subform Control, into which a Form may be embedded.

The correct form for VBA in a standard Module (not the Form's Module),
would, in fact, be

Forms!MainFormN ame!SubformCont rolName.Form!Te xtBox

If you have repeated references to the TextBox, you might use

Dim tb as TextBox

Set tb = Forms!FormName! SubformControlN ame.Form!TextBo xName

and then use the Object Variable tb to refer to the Text Box, if all you
want to do is shorten the references... you will have to make the design
tradeoff of whether it is, in fact, more efficient to do it that way.

Larry Linson
Microsoft Access MVP

[luanhoxung]

hi Larry and all !!
i got the great result from ur help. 'thanks alot'
but i also get a new trouble with my project.
My english is not good, so my interpretation is not clear.
In my project i have 2 forms:
main form: F1 base on table: T1 with MAHH is primary key.
sub form: F2 base on table: T2 with MAHH is foreign key.
F1 and F2 link by a button(ToggleLi nk)
my goal is when i type a text in MAHH of F1
after that when i click on Togglelink to open F2, i also get the value in
columns MAHH of F2(new record) that are the same text MAHH of F1.
but it don't do as my mind.
Pls show me ur idea abt this.
if u can't understand, i will explain more clearly about my database.
because my data in vietnamese, so i can't show all.
thanks.

[David W. Fenton]

"Larry Linson" <bo*****@localh ost.notwrote in
news:RVLOg.960$ wU4.174@trnddc0 6:

If the VBA is in the module of the main form, you can use the "Me"
notation for currently-active form, as

Me!SubformContr olName.Form.Tex tBox

Seems rather odd that you'd use a ! for the subform control and a .
for the textbox. I'd think you'd use either:

Me.SubformContr olName.Form.Tex tBox

OR:

Me!SubformContr olName.Form!Tex tBox

I'd certainly use the latter (I never use the . for references to
controls).

--
David W. Fenton http://www.dfenton.com/
usenet at dfenton dot com http://www.dfenton.com/DFA/