Fill in Word Form using information stored in Access Sub-Form

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Hi,

I'am quite new to programming and Im having problem in transfering all the
data in Access Form and Sub-Form to the same Word Application.
It always occur that the main form and the sub form has its own VBE, i
wonder how to connect the data from a subform to the programming (VBE) in the
main form?

I really appreciate if somebody could help me to solve this problem.
Thanks.

Lea
 
i
wonder how to connect the data from a subform to the programming (VBE)
in the main form?
Click to expand...

If you want to access a control on a subform, you have to use the subform
control's Form property vis:

forms("MyForm").controls("MySubForm").Form.Controls("MyTextBox")

which can be abbreviated to

Forms!MyForm!MySubForm.Form!MyTextBox

if you see what I mean.

Hope that helps


Tim F
 
Back
Top