Visual Basic 6 - Access - Excel

[The Real Yoda]

I already have a Visual Basic form present with a combo box listing various options e.g. car types. What I want to do is query the database for all the car details that a user selects (e.g. if the box listed ferrari, Ford, TVR etc and the user selects ford then the database will display all records that contain Ford as its car type)

 

[Rich]

Given that this is an Access answer it may not be of much help, but the "Solutions" sample database shows how to limit the contents of one combo/list box based on the selection in another.

 

[The Real Yoda]

I am using Visual Basic to query the Access tables. what I want to do is make the drop down in the VB programme have a filter effect on the access tables.

Does anyone know how to do this?