Open query based on currently filtered form - Access 2007
Posted on 2008-06-23
I am trying to integrate a mail merge function with Acces 2007. I want my users to be able to narrow the list of contacts that will recieve an email by filtering fields on a form. Once the user filters the form, they would click an email button that would start the mail merge wizard. Inside the mail merge wizard, the user has to choose a table or query to get the data from. My question is this - how do I base a query on an open form's filtered records?