B
Bunky
I have a form that has an Action_Taken pull down powered by a query called
disciplinesteps. Also on this form, I have an area named points. The points
area has a default of 1.00. What I want to happen, is when the operator
selects an Action_Taken with the characters like "*FMLA*", it will
automatically change the point value to 0.00. I have got it to work when I
am checking the comments box that is entered but the pull down will not fire.
Ideas.
Here is the code.
Private Sub Comments_AfterUpdate()
If Me.Comments.Value Like "*FMLA*" Then
Me.Points.Value = "0.00"
End If
If Me.Action_Taken.Value Like "*FMLA*" Then
Me.Points.Value = "0.00"
End If
End Sub
First if works fine but the second will not. Why? (I am very new to VB.)
Thank you for your assistance.
disciplinesteps. Also on this form, I have an area named points. The points
area has a default of 1.00. What I want to happen, is when the operator
selects an Action_Taken with the characters like "*FMLA*", it will
automatically change the point value to 0.00. I have got it to work when I
am checking the comments box that is entered but the pull down will not fire.
Ideas.
Here is the code.
Private Sub Comments_AfterUpdate()
If Me.Comments.Value Like "*FMLA*" Then
Me.Points.Value = "0.00"
End If
If Me.Action_Taken.Value Like "*FMLA*" Then
Me.Points.Value = "0.00"
End If
End Sub
First if works fine but the second will not. Why? (I am very new to VB.)
Thank you for your assistance.