Reset checked boxes to default (uncheck)

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

Guest

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

Are they bound or unbound?
When do you want them to get reset - for new records; on existing
records; on existing records under some circumstances; every full
moon?

On Sun, 24 Oct 2004 00:25:01 -0700, "AL HAMI" <AL
how to reset checked boxes automatically to default status (uncheck) in form
object in Access Programming?
Click to expand...


Please respond to the Newsgroup, so that others may benefit from the exchange.
Peter R. Fletcher
 
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
 
Back
Top