check box doesn't retain value

[van]

Hi

I have a check box on a continuous form, and wish this to be unchecked each
time I enter the screen, as I am performing queries based on its value.
However, when I set the default value to 0, and select one of the check
boxes, and then re enter the screen a second time, it doesn't retain its
default value.
Any suggestions as to how this can be done or why it is happening?

 

[Brendan Reynolds]

The Default Value property applies only to new records. To set the value of
a field in existing records, you'll need to execute an update query, for
example ...

UPDATE YourTableName SET YourYesNoField = 0 WHERE Whatever