Help : Resetting a Check Box

  • Thread starter Thread starter Dimbat
  • Start date Start date
D

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
 
In the OnLoad event of the form:

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