checkboxes

[fajita]

Have a tick box/checkbox to select specific items from a
form, to show on a report. Have a query with 4 fields and
under tick the criteria is yes. Would like to unselect
items after print report so others can make there own
selections. is there a way to create another tick box
that would unselect/clear the previous selections without
manipulating the query and report?

 

[fredg]

Have a tick box/checkbox to select specific items from a
form, to show on a report. Have a query with 4 fields and
under tick the criteria is yes. Would like to unselect
items after print report so others can make there own
selections. is there a way to create another tick box
that would unselect/clear the previous selections without
manipulating the query and report?

The Chec Box is a field in the table?
You can add a command button to the form.
Code it's click event:

DoCmd.SetWarnings False
DoCmd.RunSQL "Update YoutTable Set YourTable.CheckBoxName = False;
Docmd.SetWarnings True

 

[fajita]

Yes the tick is in the table. I have enter this code and
an error message states; "Syntax error in UPDATE
statement"

Private Sub Command128_Click()
On Error GoTo Err_Command128_Click


DoCmd.SetWarnings False
DoCmd.RunSQL "Update [AI Information] Set [AI
Information].Tick = False"
DoCmd.SetWarnings True

Exit_Command128_Click:
Exit Sub

Err_Command128_Click:
MsgBox Err.Description
Resume Exit_Command128_Click

End Sub


How can I correct and make this work? Please help.