referring to subform values

  • Thread starter Thread starter lee
  • Start date Start date
L

lee

hi all,
can anyone tell me how i can pull some data out of a
subform on a form in VBA?

i am trying to export the values of several subforms on
one form into Word, but i don't know how to refer to the
subform / txtbox.

any help is appreciated.

lee.
 
To refer to a control named "MyControlName" on a subform, use this syntax:

Forms!MyParentFormName!MySubformControlName.Form!MyControlName

Hope that's self explanatory,
 
Back
Top