Saving a path of a Word document in Access

[timnicholls]

Hi,

I have been working on this for a while and need further input.

I have a merge for an individual document going out to Word.

All is working well.

I am having trouble saving the documents path automatically and updating a subform field (with the path) with each new document for each seperate client.

I do not know how to update the recordset for a new record and place the path
in the proper place. I have it set up to do it manually, you can press the "+" button to
open a dialog and find the document after you have saved it to a common file,
but I would like to automatically save the document and the path at the same time.
(When the document closes)

The coding I have so far is not all mine, but it works.

I think I should be using Application.ActiveDocument.Close to do something after Word closes then Application.ActiveDocument.FullName to get the path of where the document was saved...

A demo database can be dowloaded from me here:

http://home.iprimus.com.au/timn/Access/Access.html

All the important code is behind the cmdWord Button I think.

Can I ask a couple of people to have a look?
A couple of demo Word templates are also included so everything works as it should (so far anyway)

Thanks
Tim