Form recordsource as data source for mailmerge

[mike6271]

Hi
I have a continuous form which displays contact names and addresses, and a search box to filter records. Once the required records are displayed I would like to use a cmd button to send the records to MS Word.

Can anyone tell me please how could i reference the form recordsource in the SQL statement i'm using to create the merge?

Many thanks

 

[HiTechCoach]

I know this is not exactly what you want to do, but it may help you get started:

How to Filter a Report Using a Form's Filter