Help needed with combo box

  • Thread starter Thread starter kanthi
  • Start date Start date
K

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
 
strSQL = "SELECT * FROM VehicleTable, TestTable WHERE
TestTable.DoorTrimPanelID = VehicleTable.DoorTrimPanelID" And
TestTable.OEM = '" & Me.cboOEM & "';"
 
Back
Top