Passing data from Access to Word

[Guest]

Table includes order # and stock # for part being ordered. Form accepts
order #, looks up stock # and opens Word file with instructions for assembing
stock # in question. My code works OK to this point. Problem: The footer of
each assembly instruction includes an area that needs to be populated with
the individual order #, i.e. (within the footer of the Word doc) Order #
_______.

 

[John Nurick]

Something like this:

Dim oDoc as Word.Document
Dim lngSection as Long
...
With oDoc.Sections(lngSection).Footers(wdHeaderFooterPrimary)
.Range.Text = "This is the footer"
End With