When I clear a check box, my code still works, how do I fix this in acccess?
Posted on 2013-01-16
Here is my simple code for a check box:
Private Sub Check165_Click()
'DoCmd.OpenForm "frmExceptions", , , [ResourceID] = "& Me.ResourceID"
DoCmd.OpenForm "frmExceptions", acNormal, , , acFormAdd, acWindowNormal
[Forms]![frmExceptions]![ResourceID] = [Forms]![frmEditResources]![ResourceID]
I want to be able to uncheck a box also in order to remove the "exception", and not have the form open. What is the best way to accomplish this?