Using Check box's for crieteria

[m17347047711116]

Currently use unbound combo box's that specify the criteria for my report query
[forms]![formname]![comboboxname]

Would like to know how to use check box's to specify criteria

example

check the box for your department
check the box for your shift


and the query will use the checked box's to determine the criteria
in addition there may be 3 check box's for departments
Printing
Shipping
Molding

Thank you in advance

 

[Travis]

Check Boxes have a True/False value.

You might have better luck using an Option Group (Unless more then one department can be choosen)


With an Option Group you can set each option equal to the Numeric ID of the Department being filted for (If a Numeric Unique ID is Used) or set an invisible Text Box = the the String Value of the selected Item and then base the query on that field.

Same goes with the Shift.