[AccessD] 2007 Word merge

Thanks Randall,

Hmm.... as the document opens it tells me it is going to "Select * from 'Qry_Export Final$'.  There 
is a qry_Export Final in my application and when I run that it returns a set of 178 records. The 
document opens and displays real data, 4 records worth.  The query data is not what is displayed in 
the word document however.

If I say yes, the document opens and it looks like the document contains whatever was last merged in 
which is a major security breach since this is a loan document and I am not supposed to see the 
actual names and stuff (I get jumbled up names and such).  I see (can step through) 4 records, all 
neatly merged into the three pages of the document.

If I say no... it opens this "select data source" dialog which expects me to find the data source, 
which I haven't a clue where this data is coming from.

My understanding is that my program is exporting spreadsheets to the same location as the app, which 
it does, which are supposed to be used for the merge, which they are not.  The data is coming from 
somewhere else, said place unknown.

Word's suckage rating is approaching 99% on this one.  I just need to find out where the 4 records 
that the document is actually displaying are coming from.

I am not finding a way, whether I say yes or no to that initial question, to see a property sheet 
for a field, nor anything else which says "I am getting my data from here...".

John W. Colby

Reality is what refuses to go away
when you do not believe in it

On 3/8/2013 11:20 AM, RANDALL R ANTHONY wrote:
> John,
> You should be able to open the document and right click a field(?) and click on properties.  When the properties form is displayed the Bookmark should identify where your program is getting the data.
>