If Then and In between Help

[cranebill]

Here is what im trying to do....

If QuotedBy = "Name" And ContactID Is Between 10131 And 10242 Then Me.Text16 = "Text 1","Text 2"

How would i accomplish this with VB?

Quoted by and ContactID values are set earlier in the coding.

Bill

 

[Junior1544]

If QuotedBy = "Name" then
if (ContactID > 10131) And (ContactID < 10242) then
Me!Text16 = &quot;Text 1&quot; & &quot;Text 2&quot;
end if
end if

That's how i would do it...

that's using the same variable names and every thing you gave me...

hope this helps...

--James
junior1544@jmjpc.net
Life is change. To deny change is to deny life.

 

[kewo99]

If you want the result to be Text 1 if the condition is true and Text 2 if the condition is false:

If QuotedBy = &quot;Name&quot; and (ContactID > 10131) And (ContactID < 10242) then
Me!Text16 = &quot;Text 1&quot;
Else
Me!Text16 = &quot;Text 2&quot;
end if

Ken

 

[cranebill]

Thanx you guys, Ken your way worked like a charm... James when i tried your way is put the strings together because of the & sign im guessing.

Bill

 

[Junior1544]

that's the way i thought you were looking for based on the way I read your question... glad you got it though...

--James
junior1544@jmjpc.net
Life is change. To deny change is to deny life.