Mail Merge to Word using Access query and form

[homeless]

After I read FAQ181-271, I wonder how to create a query whose criteria is looking at the form and can have other tables, the Word doc then mail merges to that query. What is [uniquefieldname]? Is it a primary key name? Such as Account#.

 

[DougP]

Easy
I would use a unique ID like Customer ID or Invoice number from your form and in your query.
Open your query in design view.

In the QBE grid click in the "criteria" of the field to point to the form.

then put this code in there
forms![yourformname].form!TextboxName

Open your form so you can view records
then open this query and it should be seetingon a record that is using the forms ID as a criteria.

the form does not have to have all of the tables the query has.
Try it an you will see.


DougP, MCP

Visit my WEB site

http://www.barcodeone.com

to see how Bar-codes can help you be more productive