I personally would like to do the same thing but am only half way there.
I cant get a command button on a form to automatically work with the selected record.
And I cant get it to Automatically print, but maybe if i tell you what i know it will help somewhat.
I have managed to get the data from Access into word using something called a mail merge.
In MS Word, click tools, then mail merge.
Click create form letters, then active window.
This tells word that the document that is currently open is the one that needs to get data from Access
The next stage is to goto , get data, open data source.
Find your database, tell it what table to take data from.
Then edit main Document. There will be a new toolbar at the top called, Merge Toolbar, (if not click view, toolbars, Merge)
Select where you want to put each field, and click on Insert Merge field, Select the field and walla.
Now there is another button on this toolbar which takes you from two views.
The first shows you the field names and where they are on your document, the second view actually shows you your data in the document and how it looks.
Press the <<ABC>> button for this.
Then you can go through the records using the '<< < 1 > >>'.
An excelent feature of word is to be able to not print lines that are empty.
For example, you have to address in your database.
Field1: Liam Ingram Fred Ingram
Field2: 16 Church St 19 Church St
Field3: Willoughton Willoughton
Field4: Gainsborough Gainsborough
Field5: Lincolnshire
Field6: DN21 5SD DN21 5SA
Freds record in field five is empty, and you dont want a blank line in the middle of the address.
There is a button on the merge toolbar that allows you to all sorts of stuff including this.
The button is simply "Merge....."
I realy hope this helps.
All you need to do is just play around experiment.
If you find anything out on the other stages of your request then I would be glad to know aswell.
Please build on my answer anybody who can help, as it is a very powerful tool if we can produce it properly.
