clear field in continuous form

[beansmom]

I have a continuous form with a bound check box. This check box is used to choose records to be printed as labels. (I originally tried this as unbound, but it does not work on the continuous form).

My question is, "how do I clear this check box for ALL records when the form is closed?" I found this code

Dim ctl As Control
For Each ctl In Me.Controls
If ctl.Tag = "T" Then ctl.Value = 0
Next

when looking through other posts, but it only clears the current record, not ALL records.

Thanks for your help!

 

[Remou]

You will need an update query or such like. For example:
[tt]strSQL="Update tblTable Set TheField=False"
DoCmd.RunSQL strSQL"[/tt]

This will update all records in the table.

 

[beansmom]

Thanks Remou!

I created an update query, attached it to the click event of a button, turned off the warnings, added a refrsh and it works great.