I’ve a form and on behind one query (orderqry). I like to create two button on the form to select all or partial check boxes.
I found the following code but this is for a tablet. I don’t know how to fix in order to check the query.
Private Sub cmdTick_Click()
DoCmd.SetWarnings False
DoCmd.RunSQL "UPDATE tblRecord SET tblRecord.ToPrint = True"
DoCmd.SetWarnings True
Me.Requery
End Sub
Private Sub cmdUnTick_Click()
DoCmd.SetWarnings False
DoCmd.RunSQL "UPDATE tblRecord SET tblRecord.ToPrint = False"
DoCmd.SetWarnings True
Me.Requery
End Sub
Any suggestion please?