Clear Checkbox field on close of form or close of report

B

Brook

good day,

I have a form that I use to print lables for my products. on the form
there is a checkbox (printlabel) and if it is checked then my labels report
will print for those products, and I would like to when the report is closed
then the checkboxes that are true are cleard to false.

I have tried on my report close:

If Me.printlabel = true then
Me.printlabel = false
End if

however its not working, any ideas?

Thanks,

Brook
 
D

Duane Hookom

Consider running an update query:

Dim strSQL as String
strSQL = "Update tblNoName Set PrintLabel = 0"
DoCmd.SetWarnings False
DoCmd.RunSQL strSQL
DoCmd.SetWarnings True
 
Top