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 "TestResults" to added criteria to look up Contract_Type "BKR".
I need some help coding this scenario.
Sounds as though you need to create a form, and vary its underlying filter or query based on a ComboBox. If you don't get what you want here, you might repost this in the Access forum.
