Print only current record in mail merge

[iruvarum]

Hi
I am trying to mail merge a few fields from an access table into a word document and print it out.
I am trying to automate this to happen when another field loses focus.
Everything is fine until I print out the document. I find that I have only 2 options:
1. select the "all" option at the last step of the mail merge wizard that will print out the documents for every record in the table
2. select the "current record" option at the last step of the mail merge wizard that will print out the documents for the first record of the table

What is want is to be able to print out the documents for the current record that is open in the form.

Please help!

 

[rainman89]

use a query for your mail merge that is dependent on the record that is open in the form??

 

[iruvarum]

Hi rainman89
I have tried that, but the the query is not picking it up automatically form the open form. I keeps popping up an input box asking the me to maunally enter the record identifier.
I have tried checking the "update links" option too. It does not work. I also find the the "update fields" option is disabled.
What do I do?

 

[rainman89]

so in the query under the record id you need to have

=forms!yourformname.yourrecordIDfield

as the criteria changing the things in bold to match what you are looking for. did you try this?

 

[iruvarum]

yes. this is what I treid and when the query is activated an input box pops up displaying "forms!yourformname.yourrecordIDfield" requesting data