mail merge with a SPECIFIC record from access

[Guest_imported]

PLEASE HELP!!
I am trying to use vb to print a mail merge in word using an access data source.
The situation is this: I have a form that pulls a specific record from an access data source. (the record contains such items as name, address, etc etc). I want to send that record to a form letter in Word. My problem is when I perform the mail merge I am getting ALL the records from the data source instead of the specific record I'm using in the vb form.
PLEASE HELP ME WITH THIS PROBLEM -- ITS DRIVING ME NUTTS!!!!!!!!!!
Thanks

 

[dm7941]

possible suggestion: You can dynamically add and modify querys from inside VB. Base the mail merge on a query you create (or modify) with SQL from VB. The methods are all in the MSDN. Let me know if you need specific examples. David Moore
dm7941@sbc.com

 

[swilliams]

Rather than write a query to the database, you could have a flag field on your table, which your mail merge checks - in the set up of the mail merge you can add criteria - and when the record is selected on the form, update the flag so that the record is used in the mail merge, then reset the flag.

Simon