Setting the value of a checkbox to false

[Ã…sa]

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]