I've created a query in MS Access (which is a query off of a union of several tables) I would like to create a script that allows input from users from drop down boxes to further drive the basic query I have created and than display the results in MS Excel.

For example:

User selects "BKR" for the Contract_Type. I would like to use the query called "TestResult s" to added criteria to look up Contract_Type...