Access help to get current record only to Word merge.

[gabriellec]

I have a form based on a query in Access. I have written the VBA in Access and some in Word to set up the mail merge. This is all working well.

Now, I need to make the Word document only pick up the current record from the form- I can't figure out how. (currently merges all records in the underlying table).

Any ideas? Let me know if you want to see the code.

 

[nickjar2]

When I have done this before, in the query that I have used for the mail merge i have put a criteriom in like:
forms!formName!textBox.

That way the query should only return the 1 record.

Nick