MS Access and VB

[ddavis80]

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 "BKR".

I need some help coding this scenario.

[Killer42]

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 "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.

[willakawill]

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 "BKR".

I need some help coding this scenario.

Hi. How will the drop down boxes be populated?