C
cmichaud
I am having a problem enabling/disabling a field control based on a
previous selection
i have this in the after update event
Private Sub LevelID_AfterUpdate()
If Me.LevelID = 1 Or 3 Then
Me.GradeID.Enabled = True
Else
With Me.GradeID
..Value = ""
..Enabled = False
End With
End If
End Sub
and in the forms current event i have
me.gradeid.enabled = false
there are 3 choices in the levelid box. no matter what one i pick the
box goes from being disabled to enabled.
any ideas why?
previous selection
i have this in the after update event
Private Sub LevelID_AfterUpdate()
If Me.LevelID = 1 Or 3 Then
Me.GradeID.Enabled = True
Else
With Me.GradeID
..Value = ""
..Enabled = False
End With
End If
End Sub
and in the forms current event i have
me.gradeid.enabled = false
there are 3 choices in the levelid box. no matter what one i pick the
box goes from being disabled to enabled.
any ideas why?