After_Update code; Once run deactivate
Posted on 2007-03-28
Is there a way that will deactivate code onthe Forms After_update code.
I have a subform that contains 2 columns of Checkboxes - My current code automatically updates the checkboxes accordingly, however, once they have been updated I need to be able to manual change them. what do I need to do to the following code that will allow the user to manual change the checkboxes' status.
Private Sub Form_AfterUpdate()
.Fields("Primary").Value = True
.Fields("Additional").Value = False
Do While Not .EOF
.Fields("Primary").Value = False
.Fields("Additional").Value = True