Checking/Unchecking all check boxes on a form

[Andy Sutherland]

I have a simple form where in the "detail" section each
record is listed and contains a check box.

I want a macro or code to "Check all" or "Uncheck all" but
have been unsuccessful.

 

[Jim/Chris]

Create an update query that does the Checking/unchecking
and run that from a command button. You may want to put
the query in a macro so you can take advantage of the
SetWarnings command which turns off messages

Jim