Parameter Pop Up Boxes

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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.
 
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.
Click to expand...

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.
 
Back
Top