Uncheck on Close

[Guest]

I have a subform set up for the user to check next to employee names to
create labels for those employees. I would like for the check boxes to be
cleared so the next time the form is opened they are back to all blank.

I assume this can be done by putting a line of code in the On Close event of
the subform or form but I am not too familiar with writing code and
everything I have tried didn't work.

Can someone help? Thank you in advance.

 

[Douglas J. Steele]

Assuming the checkboxes are bound to a table, write an Update query that
sets that field to False in the table, and call the query in your On Close
event.

 

[Guest]

This worked perfect! Thank you so much.

Assuming the checkboxes are bound to a table, write an Update query that
sets that field to False in the table, and call the query in your On Close
event.