Selecting the correct query

[John Orban]

I have an Access database. I run a macro that opens a Word document with
merge fields already in the Word document. In spite of the fact that I have
saved the data source in the Word file (I thought), Word asks which query,
in the database, to load. I can understand that since I have two separate
queries for two separate documents and I guess Word just needs to verify
which one goes with which document.

Is there any way to pass the query along with the Word document so the end
user doesn't have to make that choice? I just want them to click the
Switchboard button and have the Word document open to the correct query.

Thanks,

John Orban
The Country School
Easton, MD

 

[Peter Jamieson]

Which version of Word (and Access) is this?

If you open the Word document manually in Word (i.e. without going via
Access) does it ask for the data source?

You can always consider getting your Access macro to automate Word and open
the correct query using OpenDataSource.