Re: Command button clearing checkboxes

When I put this in "UPDATE InputH-1 SET InputH-1.Refrigeration = False;" I am
getting an error message that states "expected end of statement" and it
highlights the word SET. Am I doing something wrong?


UrbanSpaceman wrote:
CurrentDb.Execute "UPDATE TableName SET TableName.FieldName = False;",
dbFailOnError

Is there a way to code a command button on a form that will clear all "-1"
Yes/No fields on a table to show as "0"? I tried to type in: "update
"InputH-
1" Set Chooser = 0", but am getting an error. Any ideas?

.