enable disable control

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?
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Word macro that can call cells out of Excel for a find and replace 0
Hiding a button based on a value in a table 1
Making a macro only work on certain files 2
Disable cmd button - focus problem 2
enable/disable text box based on 3 combos 2
After update disabling controls 3
Disable/enable or lock/unlock cells in VBA dependent on other cells values 2
looping through controls - for each ... next 11

Top