Parameter Pop Up Boxes

[jsmblairsville]

How can I get rid of the pop up boxes requesting the parameters in a query? The problem is that whenever I open up a mail merge document in word that is linked to the query, I have to go back into Access and click on the box and then back to word to enter the specific name I am looking for. It's driving me nuts so I would appreciate any help you can give me.

 

[John Vinson]

How can I get rid of the pop up boxes requesting the parameters in a query? The problem is that whenever I open up a mail merge document in word that is linked to the query, I have to go back into Access and click on the box and then back to word to enter the specific name I am looking for. It's driving me nuts so I would appreciate any help you can give me.

One good way is to change the paramters to point to a form: i.e.
rather than

=[Enter last name:]

use

=[Forms]![frmCrit]![txtLastName]

frmCrit would be an unbound form designed with textboxes, combo boxes,
etc. just for the purpose of entering criteria. You could put a
command button on frmCrit to open Word to your mailmerge document.