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
 
You must log in or register to reply here.

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

Search only on current field to unchecked 2
Uncheck Items in ListBox. 4
Clearing Check Box Upon File Close 4
if date field not null or >0 check check box 4
Clearing check boxes in a form 2
Clearing check boxes when a form closes 5
Total unchecked check boxes 2
Which reference libraries should i check 2

Back
Top