Hi I have a code under after_update Event,
first if and elseif codes works fine but its not working for 3rd elseif statements...
not sure what i am doing incorrect here... can someone pls help
code is :
Private Sub PlanCompleteDate_AfterUpdate()
If Not IsNull(Me.LowLevelBlocker) Then
MsgBox (" Low Level Blocker needs to be removed to claim Plancompletedate")
Me.PlanCompleteDate = ""
ElseIf IsNull(Me.workorder) And Left(Me.Solution, 2) = "AB" Then
MsgBox (" Pls enter workorder to claim Plancompletedate")
Me.PlanCompleteDate = ""
ElseIf Left(Me.Solution, 2) = "CD" Then
If (IsNull(Me.LINKWO) Or IsNull(Me.LINK)) Then
MsgBox ("Pls enter LINKWO & LINK to claim Plancompletedate")
Me.PlanCompleteDate = ""
End If
End If
End Sub