Setting the value of a checkbox to false

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

Guest

Hi,

I want to make an action button that sets the value of a bound check box to
"false". I have a form where you can choose which persons you want to add to
a send list by checking a check box. I want the action button to empty the
send list, i.e. clear all the check boxes. How can I do that?

Thanks.
Ã…sa
 
I want the action button to empty the
send list, i.e. clear all the check boxes. How can I do that?
Click to expand...

Run an Update query updating the field to False (or 0):

UPDATE sendlist SET fieldname = 0 WHERE fieldname = True;

John W. Vinson [MVP]
 
Åsa said:
I want to make an action button that sets the value of a bound check box to
"false". I have a form where you can choose which persons you want to add to
a send list by checking a check box. I want the action button to empty the
send list, i.e. clear all the check boxes.
Click to expand...


Execute an Update query to clear the field in all table
records.

Dim strSQL As String
strSQL = "UPDATE table SET [thefield] = False"
CurrentDb.Execute strSQL, dbFailOnError
 
Back
Top