How does one look at data in an open MS access aplication from MS Word
Here is there Problem,
I have a word document that has a merge linked to a query in access.
The query has a parameter that is a field in a form. The field's data is an
input from a user (account number).
I'm Opening the word document from access. When the document open, on the
AutoOpen event of the document, I triggers the merge and it looks up for the
query in access.
The problem is that when the merge is triggered it open another instance of
the database and in that instance of the database the form is not loaded,
therefore the query has no value for the parameter.
How do I set the merge to look in the database that is presently open and
not another instance of itself?
