Help anyone,

Am having problem with code attached to the after update event of a check box, please see the following:-

Private Sub E10KProblemsFound_AfterUpdate()
If Me.E10KProblemsFound = "0" Then
Me.CmbAdd.SetFocus
Me.TblFloorwalkSub.Enabled = False
Me.GeneralComments.Enabled = False
End If

End Sub

Basically if the check box is left unchecked (i.e. no) then i want to disable some fields (as they wont be relevant and will not require any data entry). For some bizarre reason i can't get this to work - have tested and access will go to the control that i have disabled????????

Any suggestions gratefully received

Your problem is that
If Me.E10KProblemsFound = "0" should be If Me.E10KProblemsFound = 0
Checkboxes are boolean fields, not text.