Select the checkbox in design view. In the property inspector, click the Dynamic button.
Clickthe lightning bolt next to Check IF and select the corresponding Recordset column. In the Equal To box, type the number "1"
For select lists, you have click the dynamic button in the property inspector as well. Click the lightning bolt next to select value equal to and select the corresponding recordset column.