VBA - Populate Word Document

[QandAdam]

I've been looking at different code to use for this but can't find one that works.

I'm wanting to create a button which populates a word document with the information currently displayed on the access form.

[TABLE="class: grid, width: 500"]
<tbody>[TR]
[TD]Word Form Field[/TD]
[TD]Access Field[/TD]
[/TR]
[TR]
[TD]txtCompanyName[/TD]
[TD]CompanyName[/TD]
[/TR]
[TR]
[TD]txtAddressLine1[/TD]
[TD]AddressLine1[/TD]
[/TR]
[TR]
[TD]txtAddressLine2[/TD]
[TD]AddressLine2[/TD]
[/TR]
[TR]
[TD]txtPostCode[/TD]
[TD]PostCode[/TD]
[/TR]
</tbody>[/TABLE]

Does anybody have the right code to use?

 

[QandAdam]

Finally got there! Thanks for the support.
One (Hopefully) final question...

The "Invalid use of Null" appears when one of the fields I want to add to the word form is blank. Is there a way to get around this so if the field is blank then return a blank value on the word document?

 

[welshgasman]

See post #10

 

[QandAdam]

It makes sense now! I misread it at first. Thank you so much