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
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