Setting a Variable based on If Then statement 1

[kab555]

Hi,
I am “teaching” myself VB (version 6). I am trying to pass a value to a variable based on an If Then ElseIf statement. The problem is that only the 1st part of the statement works. That is, if the value fits the first part of the statement, then the program works fine, but if the value does not fit the first part (therefore should fit the ElseIf section) then the program hangs. Am I doing something wrong?? Below is the piece of code that I’m dealing with.

If txtPolicy <> &quot;&quot; Then
StrPolicySelectFormula = &quot;{KB_CLAIM_POLICY_AMT_VIEW.POLNO}= '&quot; & txtPolicy & &quot;'&quot;
ElseIf txtPolicy = &quot;&quot; Then
StrPolicySelectFormula = &quot;{KB_CLAIM_POLICY_AMT_VIEW.POLNO}= {KB_CLAIM_POLICY_AMT_VIEW.POLNO}&quot;
Exit Sub
End If

I've switched the sections around, and still the program will only work if the value fits the 1st part of the statement.

 

[Jon4747]

Hi,
Don't use the ElseIf, instead use Else

If txtPolicy <> &quot;&quot; Then
StrPolicySelectFormula = &quot;{KB_CLAIM_POLICY_AMT_VIEW.POLNO}= '&quot; & txtPolicy & &quot;'&quot;
Else
StrPolicySelectFormula = &quot;{KB_CLAIM_POLICY_AMT_VIEW.POLNO}= {KB_CLAIM_POLICY_AMT_VIEW.POLNO}&quot;
Exit Sub
End If

It's either one or the other, right?

Jon

 

[kab555]

Yup, it's either one or the other! The program works now, thank you very much!!

And to think, I've been struggling with this for hours!!!! That's one gold star for you, and a smack upside the head for me.....

Kristie

 

[mmilan]

I'm still left wondering about the academic question of why the elseif didn't work... The only suggestion I can make is that the txtPolicy variable contained a NULL.