Else if Statement not executing - first if and elseif codes works fine but its not working for 3rd e

[ChobeyGuddu]

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

[pbaldy]

Are you sure it's the ElseIf and not the following If? Either set a breakpoint and step through the code or put a message box between those two lines to test.

[aytee111]

Checking for null doesn't always work, some fields require the use of "" (double quotes) for empty

[Bulzie]

I agree with pbaldy, best way to figure these things out is to put break point then F8 step through each line, checking the values (mouse over the fields) to see if they are what you are expecting.

Are you sure there is a "CD" as left(2) in me.source in one of the records or else it won't go into that next If.

[ChobeyGuddu]

HI pbaldy
Yes, its working uptill breakpoint...
see the image...

Are you sure it's the ElseIf and not the following If? Either set a breakpoint and step through the code or put a message box between those two lines to test.

[ChobeyGuddu]

Yes, there are 2 different values in me.Solution - AB and CD - so not sure what is going wrong here...

[pbaldy]

Can you attach the db here?

[pbaldy]

You might try this test:

If Len(Me.LINKWO & vbNullString) = 0 Or Len(Me.LINK & vbNullString) = 0 Then

[ChobeyGuddu]

Checking for null doesn't always work, some fields require the use of "" (double quotes) for empty

Thanks aytee111,
Replacing null with "" (Double quotes) worked fine...

Thank you all for your time and efforts to help me getting there...

Cheers
Guddu.

[pbaldy]

FYI, the test in post 8 will check for both Null and a zero length string (""). I'd use it or something like it (Nz(), etc) that checks for both.

[ChobeyGuddu]

FYI, the test in post 8 will check for both Null and a zero length string (""). I'd use it or something like it (Nz(), etc) that checks for both.

Thanks pbaldy,
I would give it a go now and let you know..

Cheers
Guddu.