Criteria Errors

  • Thread starter Thread starter Glen
  • Start date Start date
G

Glen

Im trying to set criteria to filter a table with drop
down boxes, when i try to filter in the fields with the
drop down boxes I get the error message "Data Type
Mismatch In Criteria Expression".After reading the reply
to my previous problem Im guessing that its the Drop down
box that is the culprit? Is it as simple as changing the
data type of the ddbox to text box and then adding combo
box in design view?
I Love You All
For Your Help!
Glen
 
Glen,

Check the bound column, colum count and column width properties of the combobox.
Are you aware that the value of the combobox is the value of the field in the
bound column? You may see some text in the combobox but depending on the
settings of these properties, the combobox may have a numerical velue.
 
So, Is there any way to make the advanced filter or the
Query find the selected criteria in the combo box or is
this impossible? lets say my whole table is combo boxes:
type of car- color of car- dealer name.Each field has
multiple possible values ie;Ford,chevy etc. and red, blue
etc.I want to do a Query to search for all red fords sold
by joe blows used cars. Is it possible?
 
Yes. As you select criteria you are modifying the WHERE clause of a SELECT
query. Your form needs to build this query and then run it to return the
result you expect.
 
Back
Top