Hi

From the posts you have been making, you are having "fun" with Access at the moment 🙂

I agree with Wendell's comments about sharing data with other Office apps not being a straight forward topic. I have used Automation to get data into, and to manipulate, Excel spreadsheets, and it does require a bit of extra reading, not to mention the mandatory banging of one's head against brick walls.

But the methods Wendell mentions are all what I would call "push" methods. Don't forget that the other possiblity is to use a "pull" method, which may offer a simpler solution. This could be something simple like using the Word merge function and a query into your database, or something more complex like a macro in Word - creating a data connection to your database, a recordset and a procedure for dealing with the resulting data.

Again, my experience of this method lies more with Excel, and whether or not a "pull" method is suitable is a topic on its own, with its own set of issues to be considered. But nonetheless it is a valid method and worthy of a look.

Cheers

Rowan