Help : Resetting a Check Box

[Dimbat]

Hi

Help please :

Is there a way to mass reset check box values to NO on loading a form.

I am running office 97, the check box field is called select and is in a
table called Completed.
The selecting of the check box is to enable a re-export of selected
records to a mail merge document.

Many thanks for any help

 

[Wayne Morgan]

In the OnLoad event of the form:

CurrentDb.Execute "UPDATE Completed SET Completed.Select = False;"

 

[Dimbat]

In the OnLoad event of the form:

CurrentDb.Execute "UPDATE Completed SET Completed.Select = False;"

Thankyou very much, it works a treat