Macro that checks or unchecks all Checkboxes in a table

[Alfboy]

I need to make a macro that can uncheck an entire column of checkboxes in a table. I tried making a macro do just that, however when I typed Tables!

[visited] in the item field and set the expression field to "No" Access tells me that it cannot find the table. That I did not specify which type of table I wanted, even though I clearly have! What I am doing wrong, and can anybody give me some examples of a macro that does what I want, please?

Thank you, all of your help would be greatly appreciated.

 

[FoFa]

Use an update query
UPDATE MyTable
SET ChkBox = False
WHERE some criteria

would UNCHECK the check boxes
If you want to do all rows, leave the criteria out
If you want to CHECK them, use TRUE instead of False

 

[Alfboy]

I cannot find update query on the list of functions for macros. Can you be more explicit. Sorry, this is the first time I have used access, so I am learning as I go.

 

[jsanders]

I cannot find update query on the list of functions for macros. Can you be more explicit. Sorry, this is the first time I have used access, so I am learning as I go.

Query is to a macro, as a bunch of bananas is to a peach.

 

[Alfboy]

Use an update query
UPDATE MyTable
SET ChkBox = False
WHERE some criteria

would UNCHECK the check boxes
If you want to do all rows, leave the criteria out
If you want to CHECK them, use TRUE instead of False

Ummm, how do you do this?