Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations gkittelson on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Mail merge query won't populate a parameter field

Status
Not open for further replies.

kazprog

Programmer
Jan 28, 2004
11
GB
I have a .mdb database and it runs mail merges to produce administrative letters. When the user wishes to do this, they press a button, this links to a word document which runs a query back in Access.

On one of the access fields, I have a parameter as follows
The form is already open and the Combo87 has the application number I need to be able to run the correct work document

[Forms]![Word View - Select Application Number]![Combo87]

The problem I am having is the parameter screen asking for the number is always appearing instead of just opening the word document with the correct number in it.
Has this happened to anybody else.
I have tried manually opening the query once the button is pressed, but this does not make any difference.

Any ideas please

Thanks
 
I have just noticed that the database opens up again once I press the button to run the mail merge. If I can work out how to stop it opening up again I think it will stop asking for the parameter in the query.

Has this happened to anybody else.

 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top