ACCESS cannot access variables in SQL queries except through the use a Function statement. So, for this situation just create a Global variable for each in a database module along with a Function to call it. Then reference the Function Call in the criteria line in each query.
Example:
Global vName as string
Function Name()
Name = vName
End Function
Now in the query you can use the Function to capture the Global variable value and make the appropriate criteria comparison to the data in a table.
Example:
Select tblClients.Name, tblClients.Address, tblClients.City, tblClients.State
FROM tblClients
WHERE tblClients.Name = Name();
The values of the global variables must first be set in your code prior to running the queries.
Example:
vName = "Smith"
DoCmd.OpenQuery "qryClientAddresses"
These global variables can then be used by all of your queries and query the same records for information.
Bob Scriver
