Option for running SQL repeating before I can open report
I have a template report in MS Word that I am using a mail merge in it runs from a query out of MS Access. I have added some fields in the query, and everytime I add them to the template the box that says:
"Opening from this document will run the following SQL command:
SELECT * FROM 'qryAppraisal'
Data from your database will be placed in the document. Do you want to Continue?"
Then, when I open a new report from the template, this box pops up 10-15 times before it lets me open the report.
What am I doing wrong here? Is it that you can't add fields to a template (via editing: i.e. right clicking the template and selecting open) after it has been created?
|