Hello!!
I have a query which is displayed in a form, next to each result is a button that opens another form which is filtered to that specific record.
I'd like to make a button with VBA code so that it opens up a mail merge document with only that filtered data in.....any help much appreciated! Currently it is showing all the records in the query it is attached to. I was thinking it would be best to append the filtered data into a 'temp query' in which the mail merge can use....if anyone knows the best way forward that would be great.
I have a query which is displayed in a form, next to each result is a button that opens another form which is filtered to that specific record.
I'd like to make a button with VBA code so that it opens up a mail merge document with only that filtered data in.....any help much appreciated! Currently it is showing all the records in the query it is attached to. I was thinking it would be best to append the filtered data into a 'temp query' in which the mail merge can use....if anyone knows the best way forward that would be great.