Select All Checkboxes in MS Access Form

[shepkrm]

i have an access form with multiple checkboxes on it. i would like users to have the option of "select all" on the form, where all the boxes would be checked.

any ideas on how i can do this?

thanks in advance,
becky

 

[PHV]

A starting point:
For Each ctl in Me.Controls
If ctl.ControlType = acCheckBox Then ctl.Value = True
Next

Hope This Helps, PH.
Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884 or FAQ222-2244