I'm having some trouble with queries gathering information from Cobo boxes.
I've set up a form to launch a query, in it there is a combo box(combo6) and a search button. The form is called "FrmGenericq".
Below is the SQL for the Query:
SELECT TabItem.Type, TabItem.Location, TabItem.Description, TabItem.Quantity, TabItem.Serials, TabItem.Supplier, TabItem.[Date Purchased], TabItem.Value, TabItem.Notes
FROM TabItem
WHERE (((TabItem.Type)=[Forms]![FrmGenericq]![Combo6]));
What this should do is when I've selected a value from the combo box and launched the query, it should take the value as if I had entered the value manually, and search for all records in the table "Item" where the field "Type" matches what was in the combo box. I've done similar queries for check boxes and they work fine, but there seems to be a problem with reading the information from combo boxes. I've tested the Query by typing values into it manually and it works fine, it just won't get the values from the combo box. The code looks fine to me so if anyone thinks they might know what I've done wrong any help would be greatly appreciated.
I've set up a form to launch a query, in it there is a combo box(combo6) and a search button. The form is called "FrmGenericq".
Below is the SQL for the Query:
SELECT TabItem.Type, TabItem.Location, TabItem.Description, TabItem.Quantity, TabItem.Serials, TabItem.Supplier, TabItem.[Date Purchased], TabItem.Value, TabItem.Notes
FROM TabItem
WHERE (((TabItem.Type)=[Forms]![FrmGenericq]![Combo6]));
What this should do is when I've selected a value from the combo box and launched the query, it should take the value as if I had entered the value manually, and search for all records in the table "Item" where the field "Type" matches what was in the combo box. I've done similar queries for check boxes and they work fine, but there seems to be a problem with reading the information from combo boxes. I've tested the Query by typing values into it manually and it works fine, it just won't get the values from the combo box. The code looks fine to me so if anyone thinks they might know what I've done wrong any help would be greatly appreciated.
