If you always want to clear all of the checked records, you can create an update query to update all the records that have the check box checked to make them equal to false.
Without field names, it is a little tricky to give you an example, but here is a try:
- UPDATE tblGroceryList
-
SET CheckBox = False
-
WHERE CheckBox = True
You can then run this query in an On Click event for a button. It is possible to be much more selective in which ones to uncheck, but without further knowledge of how you have your database setup, I can't make any suggestions.
FYI, it helps people help you if you provide more information such as field, control, table, form, query or report names that are affected.