Code/Macro for Find and Replace with Checkbox

[mortonsafari]

I have a database in which the user can select records to print via a checkbox (Yes/No | True/False | -1/0 as the case may be) and then a query that runs through a form to show the list of the records selected with the Print checkboxes as Yes | True | -1.
I want to include a button to change the checkbox for each record from Checked back to Unchecked (Yes back to No | True back to False | -1 back to 0).
Rather than have to Uncheck each individual record, I’d like to have a Macro or Code that will do all the displayed records in one hit.
I have looked at Code and Macro but can’t seem to find a “Find and Replace” type action that will allow me to do it all in one go.


Can anyone suggest an answer for me please.
Many thanks, mortonsafari

[June7]

Users should not work directly with tables and queries - only forms and reports.

Easiest is an sql UPDATE action to set all records in table to 0.

CurrentDb.Execute "UPDATE tablename SET fieldname=False"

[mortonsafari]

Thanks June7. The users are only selecting records via a Form and selecting the Checkbox there. They then select the other form to allow them to Unselect the checkbox. I just want to make it easier to Uncheck all the Checked boxes.

[mortonsafari]

Thanks June7. Sorted it out by

Private Sub Command6_Click()
CurrentDb.Execute "UPDATE q_ClearPrintBox SET Print=False"
Me.Refresh
End Sub

Many thanks