Disable toggle off option

[Gryphen957]

I have a check box that, when selected, brings up a form. When the form comes up, it is filtered to show only information relating directly to the record that contains the check box.



I am wondering if there is anyway to prevent the box from being unchecked while there is related information in the form.

Currently, if I uncheck the box, I lose the visual indicator that the related information is there.

[pbaldy]

You should be able to test the data in the before update event of the checkbox, and if appropriate this will stop the update:

Cancel = True

You can test with DCount or a recordset.