I am the admin for a database that has client records. I need to mail merge data from a query, but need to pass two variables to the query before I merge the results of it. I want the user to be able to run a command and be prompted for two variables and then have access merge it results of that query (or SELECT statement) with one button. In the past I have been having the end-user edit a query in design mode, save it, and then run the merge from that query that already has criteria in it.

I would love to do it in VBA and SQL. Where can I find some code for this type of subroutine?

This is very elementary. If you just want them to be prompted for variables, put these statements in the criteria line (in the query designer) (ex.):

This is a straight parameter
[Please enter the first parameter:]

These are like parameters:
Like [Please enter the first letters of the last name:] & "*"
Like "*" & [Please enter any characters in the string:] & "*"

This is two parameters for a date column:
Between [Please enter start date:] And [Please enter end date:]

You can also have the query fetch the parameter from a combo box or text box, but this limits its use to the one form:
[Forms]![frmMyForm].[cboMyCOmboBox]

This should get you started. You can also search help for query parameters.

HTH

mmcdonal