Enable Field off Text Box

[SpdRacerX]

I did some research on this topic but it's not seeming to work in my form.

I have a form with various fields.



I need Field [Reason] to be enabled if Field [Over] = "Yes"

I've tried many variants of this the AfterUpdate of Field [Over] but for some reason it's not working.

[alansidman]

Do you have an on load event for the form that disables the Reason Field?

[SpdRacerX]

Tried that but it's still not working.

I have the following in the Load Form:

Private Sub Form_Load()
Me.Reason.Enabled = False
End Sub

And the following in the After-Update:

Private Sub Over_AfterUpdate()
If Me.Over.Value = "Yes" Then
Me.Reason.Enabled = True
Else
Me.Reason.Enabled = False
End If
End Sub

[SpdRacerX]

My fields are populated from a query if that helps...

[SpdRacerX]

I created a Text Box where I can manually enter the words "Yes" and it worked off of that Text Box.
But when I change the Control Source of the Text Box to Equal [Over] then it doesn't.
Is the only way it will work is off of a Manual-Entry Text Box?

[SpdRacerX]

Basically the purpose of the [Reason] field is to enable the user to enter a reason that the trouble ticket was over the required alloted time.
The [Over] field works where if the time is over then it equals "Yes" or "No" if it is not.
Now I need the [Reason] field to be enabled if the [Over] field is equal to "Yes" so that they may list the reason why.