The checkbox is used elsewhere and I am just using the value collected when they checked the box.
Just make sure that the checkbox defined elsewhere actually is updating the tablename.fieldname as expected when the checkbox is checked. What is the controlsource of the checkbox and how are you updating the table value?
