Query Input Form

[gtimmies]

Hey guys,

I'm working on a query input form that allows the user to enter information based on the make of the car and run a query based on the information they input. Currently, I have set it up so that the combo box gets the car make from the tCar which has VIN# as the primary key and has information regarding the make of the car. The criteria in the query is [Forms]![Inventory Query]![Combo45]. The query, however, returns no data. If I were to change this combo box to a text box and enter information on the make of the car, the query returns to correct data.

Could you please let me know how to set up the combo box and criteria so that the query returns the correct data?

Thanks!

 

[JHB]

It look correct, but maybe value shown isn't the value the query reads, if there is a hidden column in the combo box or if it is bound to an other column.
Try by placing the following in you code before you run the query, to see what the query reads.

MsgBox(Me.Combo45)