Access change Word form field value

[Jake F]

I'm creating a form in Word to send to different clients and then pull back
into access when they fill it out. I need to fill the information regarding
their name, address,etc before I send it to them. Is it possible to do that
from access vba saying wordform!textbox1.value = "A", similar to what I would
do on a form in access? Thanks.

 

[Piet Linden]

I'm creating a form in Word to send to different clients and then pull back
into access when they fill it out.  I need to fill the information regarding
their name, address,etc before I send it to them.  Is it possible to dothat
from access vba saying wordform!textbox1.value = "A", similar to what Iwould
do on a form in access?  Thanks.

If you create a bookmark in your Word document, then you can just dump
the value in

wrdDoc.Bookmarks("BookmarkName")=Forms!MyForm!MyControl

or you could use a recordset if you have to do a lot of these.

 

[Jake F]

Great, thanks!

If you create a bookmark in your Word document, then you can just dump
the value in

wrdDoc.Bookmarks("BookmarkName")=Forms!MyForm!MyControl

or you could use a recordset if you have to do a lot of these.