check box doesn't retain value

  • Thread starter Thread starter van
  • Start date Start date
V

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?
 
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
 
Back
Top