referring to subform values

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.
 
P

Peter De Baets

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

Forms!MyParentFormName!MySubformControlName.Form!MyControlName

Hope that's self explanatory,
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top