Uncheck on Close

  • Thread starter Thread starter Guest
  • Start date Start date
G

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.
 
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.
 
This worked perfect! Thank you so much.

Douglas J. Steele said:
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.
Click to expand...
 
Back
Top