If you are talking about Boolean values in a table, the "Yes/No" type, it is either Yes or No, no 1 or 2. If you are talking about a checkbox in an Access Form, you can use a variable to be set by the AfterUpdate event to where if the Checkbox is checked, set the variable to 2, and if not checked, set the variable to 1, and then store it into the database. Instead of a "Yes/No" you may want to instead use a "Number/Byte" field and store a 1 or 2 in there based on the checkbox on the Access Form.

It should be Check0.Value for what you want to check on, or whatever you named the control.

My memory of Access is a bit rusty, but I still have some skills in it.