Setting the value of a checkbox to false

[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

 

[John W. Vinson]

I want the action button to empty the
send list, i.e. clear all the check boxes. How can I do that?

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

UPDATE sendlist SET fieldname = 0 WHERE fieldname = True;

John W. Vinson [MVP]

 

[Marshall Barton]

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.

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