I have a form that has multiple cbo controls where the user can search for data. They all work except the one for the Bumper Number. I created them all the same way so im not sure what the problem is. When I look at the form in design view, the control for the bumper number is different from the rest of the controls. I am not sure if this is the problem, but I can seem to get it to look like the others. I have included a screen shot of both the form and the table in design view.
This is what my query looks like for my search form.
SELECT tblVehicles.ID, tblVehicles.GSATagID, tbluGSATag.[GSATag #], tblVehicles.[Bumper #], [tbluDivision POC].[Division POC], tblVehicles.[Division POC_ID], tbluDrivers.Name, [tbluDivision List].Division, tblVehicles.DivisionID, tbluShop.Shop, tblVehicles.ShopID, tbluMake.VehicleMake, tblVehicles.MakeID, tbluYear.VehicleYear, tblVehicles.YearID, [tbluVehicle Description].[Vehicle Description], tblVehicles.[Card (04980)], tblVehicles.VIN, tblVehicles.GVWR, tblVehicles.[GSA EQ CD], tblVehicles.Notes
FROM [tbluVehicle Description] INNER JOIN (tbluShop INNER JOIN ([tbluDivision List] INNER JOIN (tbluYear INNER JOIN (tbluMake INNER JOIN (tbluDrivers INNER JOIN ([tbluDivision POC] INNER JOIN (tbluGSATag INNER JOIN tblVehicles ON tbluGSATag.[GSA TagID] = tblVehicles.GSATagID) ON [tbluDivision POC].DivisionID = tblVehicles.[Division POC_ID]) ON tbluDrivers.[Driver ID] = tblVehicles.[Driver ID]) ON tbluMake.VehicleMakeID = tblVehicles.MakeID) ON tbluYear.VehicleYearID = tblVehicles.YearID) ON [tbluDivision List].DivisionID = tblVehicles.DivisionID) ON tbluShop.ShopID = tblVehicles.ShopID) ON [tbluVehicle Description].VehicleID = tblVehicles.VehicleID
WHERE (((tblVehicles.GSATagID)=[Forms]![frmVehicleSearch]![Combo33])) OR (((tblVehicles.[Bumper #])=[Forms]![frmVehicleSearch]![Bumper #])) OR (((tblVehicles.DivisionID)=[Forms]![frmVehicleSearch]![Combo35])) OR (((tblVehicles.ShopID)=[Forms]![frmVehicleSearch]![Shop])) OR (((tblVehicles.MakeID)=[Forms]![frmVehicleSearch]![Make])) OR (((tblVehicles.YearID)=[Forms]![frmVehicleSearch]![Year])) OR (((tblVehicles.[Division POC_ID])=[Forms]![frmVehicleSearch]![Division POC]));
Any help would be greatly appriciated