Access/Word Forms

  • Thread starter Thread starter Sharon
  • Start date Start date
S

Sharon

I have a main form and a subform (one to many
relationship).

The main form contains patent information: i.e., Patent
No., Title, filing date, Inventors, etc.
The subform contains a list of inventors and their home
addresses, citizenships, etc.

I have forms in Word that I need to fill in using this
Access database. The problem is that there could be more
than one inventor on each patent. How do I get the Word
document to recognize that there is more than one
inventor listed on the form? The subform record just has
Inventor, Address, City, State, Zip, Citizenship.
 
There is no straightforward way of doing what you want to do by
merging to Word. What you have to do is use Automation to write from
Access VBA code into a Word Document. The 2000 and 2002 editions of
Litwin et al.'s excellent Access 200n Desktop Developer's Handbooks
have very good chapters on this and some valuable sample code.
 
Back
Top