check box with a reset (1 Viewer)

Jon123

Registered User.
Local time
Yesterday, 23:49
Joined
Aug 29, 2003
Messages
668
I have a people table in my database and there is a yes/no check box that is used to confirm weather or not the person has completed paperwork required for a certian time. So the table could have thousands of people and I would like to reset this Yes/No field to No on the click of a command button for everyone at the same time. Is this something that can be done easily?
 

pbaldy

Wino Moderator
Staff member
Local time
Yesterday, 20:49
Joined
Aug 30, 2003
Messages
36,137
Behind the button:

CurrentDB.Execute "UPDATE TableName SET FieldName = False"
 

Users who are viewing this thread

Top Bottom