Reset checked boxes to default (uncheck)

A

AL HAMI

how to reset checked boxes automatically to default status (uncheck) in form
object in Access Programming?
 
F

fredg

how to reset checked boxes automatically to default status (uncheck) in form
object in Access Programming?
Click to expand...

Assuming the check box is a field in a table:

CurrentDb.Execute "Update YourTable Set YourTable.CheckBoxName = 0;",
dbFailOnError

You could also use RunSQL:

DoCmd.SetWarnings False
DoCmd.RunSQL "Update YourTable Set YourTable.CheckBoxName = 0;"
DoCmd.SetWarnings True
 
Top