A day late, but I just figured out why your check boxes won't respond to mouse clicks: because they're in an option group.
When in an option group, check boxes and radio buttons lose some of their events. (Under the covers, Access actually substitutes a different kind of control which is a cut-down version of a normal check box or radio button.)
What you should depends on whether you really want an option group here. An option group links the check boxes so that only one can be selected at a time. If the check boxes are truly independent, and you only put them into an option group for the visual effect, you should replace the option group with a rectangle and a label. The check boxes will then have the full complement of properties.
If the check boxes should be linked, then leave the option group present, but instead of detecting mouse clicks, respond to the AfterUpdate or Click events of the option group itself. The individual check boxes (within an option group) have an OptionValue property which you should set to a different value for each one. When you click a check box, its OptionValue becomes the value of the parent option group, which then gets BeforeUpdate, AfterUpdate, and Click events. (Note that the Click event will not occur if you tab to the check box and press the space bar to select it.)
Rick Sprague
Want the best answers? See faq181-2886
To write a program from scratch, first create the universe. - Paraphrased from Albert Einstein
