Check Boxes And / OR
Hi Jason,
I have a check boxes in a search form. Currently the field the check boxes refer to can have one or many values from a recordset. When the tick boxes are selected individually, they return the correct results, i.e. if check box 1 is selected, then if the value is in the field alone, or with other values, it returns the correct value. If however, more than one check box is selected, it returns the values where there is more than one in the field, and not the values where it is alone in the field (I hope this makes sense!).
I have included the file for you to look at.