Check Boxes

[Jack]

I am trying to create a macro that will clear check boxes that have been
selected. Is there any easy way of doing this?

Any help would be appreciated.

Thanks

 

[Steve Schapel]

Jack,

This is a job for an Update Query. Update the checkbox field for the
applicable records to 0. If you want to use a macro to make this
happen, use an OpenQuery action in your macro to run the update query.
If so, you might want to put a SetWarnings/No action in the macro before
the OpenQuery action, to suppress the display of the action query
confirmation prompts.