All you should need to do is enter me. in from of all objects. This should be placed in the module of your form in VBA. I would also use the AfterUpdate event.
Sub CheckStatus()
If (me.CheckBox1.Value = True Or me.CheckBox2.Value = True Or me.CheckBox3.Value = True) _
And me.TextBox1.Value = "" Then
me.CheckBox4.Value = True
End If
End Sub
Private Sub CheckBox1_AfterUpdate()
CheckStatus
End Sub
Private Sub CheckBox2_AfterUpdate()
CheckStatus
End Sub
Private Sub CheckBox3_AfterUpdate()
CheckStatus
End Sub
Bookmarks