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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Populate a table based on check box status 2
Content Control Box Issue - Please Help! 0
Word 2010: trouble saving font/size 9
Word OLE to check spelling in text box 1
Search only on current field to unchecked 2
Clearing Check Box Upon File Close 4
Uncheck Items in ListBox. 6
if date field not null or >0 check check box 4

Top