Use Parameter Queries in a Mail Merge Document

[traquino98]

I have used my access database in the past with Word and the Mail Merge
feature, but now I need to use a parameter query to supply the information.
Is that possible? I have tried it, and it never works becuase the query is
not run until in Word, and then it doesn't know how to do the user-input on
it. Please help.

 

[tina]

chances are that this has come up before. have you tried doing a search in
Google Groups, under microsoft.public.access.*, to see if somebody has
already posted a solution in the past? if you can't find anything, you might
try creating a form with unbound controls where you can enter the parameter
value(s). then change the criteria in the query to refer to those form
controls, as

Forms!MyFormName!MyControlName

i've never tried this solution, so it's an experiment for both of us. <g>

hth