Linking Word Fields to an Access Database

[Chris Waller]

I have created a complex form in Word. There are a large
number of fields on the form. The first one contains the
National Insurance Number, the second the name of the
person and the third is the sex of the person. All this
data is also held on an Access database. Ideally what I'd
like to do, is to input the National Insurance number in
the first field on the Word Document and for each of the
subsequent fields to be updated with the correct data from
the Access Database (a bit like using the Vlookup formula
in Excel). I would also like to be able to input the first
line of the address and then for the subsequent 5 lines of
address to be updated again from data held in a table on
Access. The reason I want the integrity of the fields to
stay intact is so that I can copy the document and change
the National Insurance Number and then subsequently save
that document. I am sure this can be done using form
fields or perhaps some VBA behind the scenes. Or perhaps
linking the fields on in both applications. What I want to
do will save many man-hours work, but as my knowledge of
VBA and or linking different applications is somewhat
limited I don't know where to start. Any help would be
greatly appreciated. I am also working on the 97 platform.

 

[JulieD]

Hi Chris

i personally would approach it from a different direction ... i would set up
a mail merge between a word template and the access db as the datasource.
When i needed to generate the document i would merge only the record i was
interested in ... then all the fields will be filled in correctly each
time.

is this a possible way forward?

Cheers
JulieD

 

[Chris Waller]

JulieD,

Thanks for your prompt reply. It is a different approach,
one which I will take a serious look at. Thanks once again
for you reply.