Clearing check boxes in a form

  • Thread starter Thread starter Tom
  • Start date Start date
T

Tom

I have an attendance form I use daily in access 2003. I use a checkbox to
indicate whether the employee was absent or not. By default it is unchecked.
Once I have used one of the check boxes and I append to an attendance table,
the next time I open the form, the box is still checked. What command can I
use in the form to reset all check boxes when the form loses or after I
append the information.

Thanks
 
Forms display data that's displayed in tables.

If your check boxes are checked, that's because they're bound to data fields
in the table that have a value of True.

Either your form is bound to an incorrect recordset, or else you need to use
an update query to set all the appropriate fields in the table to False.
 
Sorry, that first line should have read "Forms display data that's
contained in tables."
 
Back
Top