Check Box Value - Disable Control Problem (1 Viewer)

[LisaP]

Please see the following code:-

*********************************************
Private Sub Problems_Found_AfterUpdate()
If Me.Problems_Found = 0 Then
Me.GeneralComments.SetFocus
Me.E10K.Enabled = False
Me.E10KProblemsFound.Enabled = False
Me.TblFloorwalkSub.Enabled = False
Me.GeneralComments.Enabled = True
End If
End Sub
*********************************************

If the value of the check box [ProblemsFound] is no (i.e. 0) then i want to disable the control [TblFloorwalkSub] (which is a sub form for holding problems found)but for some banging-your-head-against-a-wall reason its not working.

Any ideas would be gratefully received.

 

[Jack Cowley]

Try this line of code using our form names, etc.:

[Forms]![MainFormName]![SubFormName].[Form]![SubFormControlName].Enabled = False