I have a query created that writes data to a temporary table. The table will only have one record ever. But them somehow within Access I would like to merge that data with a Word template document and print that Word document via a command button on a form.
So basically here are the steps.
1) User clicks a command button on a form.
2) The onclick event of the command button deletes previous data and creates the new table data (I have this working already)
3) The data is merged with the Word document which will reside in the same directory as the front-end file of the Access database.
4) The Word document will print.
And with steps 2-4 happening without the user having to do anything. Is this possible?