Help needed with combo box

[kanthi]

I have 3 combo boxes OEM,VehicleModel,VehicleYear ,a checkbox titled
ALL and a search button on a form.

I am writing a query to display all the attributes of the testtable of
a particular oem ,vehicle model and year as selected by the user.I am
not able to capture the value selected in the combo box can anyone help
me on the same

strSQL = "SELECT * FROM VehicleTable, TestTable WHERE
TestTable.DoorTrimPanelID = VehicleTable.DoorTrimPanelID" And
TestTable.OEM = (value selected in the combo box should go in here)

Thanks a lot

 

[Klatuu]

strSQL = "SELECT * FROM VehicleTable, TestTable WHERE
TestTable.DoorTrimPanelID = VehicleTable.DoorTrimPanelID" And
TestTable.OEM = '" & Me.cboOEM & "';"