Check Boxes

  • Thread starter Thread starter Jack
  • Start date Start date
J

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
 
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.
 
Back
Top