Clearing check boxes when a form closes

[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

 

[Jeff Boyce]

Tom

Is the form bound or unbound?

Is the checkbox control bound or unbound?

Is the form a continuous form or a 'single form'?

More info, please!

Regards

Jeff Boyce
Microsoft Office/Access MVP

 

[KARL DEWEY]

Are the check boxes bound to your attendance table?
Are the defaults set to 0 (zero), No, or False?

 

[Tom]

It is bound to a table called studentT
but is updateing the table called attendanceT
the default yes and no apply

 

[Tom]

it is a form based on a query and then the query updates and appends a table
caled attendanceT
the defaults are the noral defaults

 

[KARL DEWEY]

Do you use a second query to append the data?

You did not answer whether the check boxes were bound or not. If they are
bound to your table called attendanceT then they are reflecting the data from
a previous record entry.