Happy new year to all,
I have a query which is driving a form showing a list of parts we supply.
The table which the query is filtering is called tbl_Products.
In tbl_Products i have a few check boxs for each part. These check boxes are used to help filter the results in the form. The same parts can be used on different machines, so i tick the check boxes for the machines which the same part
So part number XYZ may be used on machine ABC & F. so i tick the boxes in the table for ABC & F for part XYZ
My result are not filtering how i would like them to. In the form i want to click on all parts relating to machine A but it only shows the parts where A is the only check box selected. I would like it to show all the parts where checkbox A is selected. If checkbox A & B have been selected i would like it to show that parts to. So basically any combination as long as the part has A selected.
in my query, under Criteria, if i put -1 under check box A and this works. It shows parts with just A selected and other combinations containing A and "whatever"
however, i can't used -1 as the form is being driven by some other check boxes in the main form. So i need to see what the value of the check box is in the main form to filter the results.
In the design view of the query, i tried the following:-
I have the same code for each machine in the criteria.
This didn't work as it would only display the part if i selected the right check boxes.
I think i need to mimic the -1 value somehow? So i look at the form, look at the filter checkboxes. i noticed say checkbox A (machineA) is selected. I convert this value to -1 and reference it in the query somehow, whick inturn drives the form to show only the parts where A have been selected any any combination involving A.
that's what i think i need to do, but i would be grateful of any help.