Dynamic Merging to Word

[Guest]

I have a table called "Tours" that I have merged to a word document. The
table contains information such as names, dates, buildings, and so on. Right
now I am using a query to select all of the relevant fields for the mail
merge. However, it is very difficult to make it user-friendly.

On the form that is linked to the Tours table, I would like to put a command
button that will update the query (or perhaps just create one) to include
just the record that the user is viewing, and then use that query as the
source for the mail merge and print it off.

.... that sounds rather difficult. But I'm sure I'm not the only one who has
tried to do it. Has anyone figured this one out?

Thanks!

Nick

 

[Albert D.Kallal]

I have a working solution posted here that does what you want.

http://www.members.shaw.ca/AlbertKallal/msaccess/msaccess.html

There is a also step by step instructions on how to use the above in your
"existing" applications