<div>
Instead of an IF..ELSE..END If.. &nbsp;Or IF..ELSEIF.. &nbsp;Why not use a CASE Statement instead? &nbsp;It will force a true condition which would be ideal in this example.<br />
<br />
HTH,<br />
<br />
Kent
</div>


Instead of an IF..ELSE..END If..  Or IF..ELSEIF..  Why not use a CASE Statement instead?  It will force a true condition which would be ideal in this example.

HTH,

Kent

<div>
Guys, I hope you don't mind. To be fair I have split 50/50 because you both came up with the same answer only seconds between each other.<br />
<br />
Thanks guys. Exactly what was needed. It was wrecking my brain!!
</div>


Guys, I hope you don't mind. To be fair I have split 50/50 because you both came up with the same answer only seconds between each other.

Thanks guys. Exactly what was needed. It was wrecking my brain!!

<div>
<div class="content wysiwyg-content">
All,<br />
<br />
I am struggling with getting the following syntax to work and wondering if someone can help put it right.<br />
<br />
My CboFromState = 1 and CboToState = 2 but each time I parse this code, it skips to the End If instead of doing what I want it to do if values are found in both CboFromState and CboToState.<br />
<br />
ElseIf IsNull((Me.CboFromState) = False) And IsNull((Me.CboToState) = False) = True Then 'DATA FOUND IN BOTH FROM AND TO STATE<br />
<br />
Any help much appreciated.<br />
CF
</div>
</div>


All,

I am struggling with getting the following syntax to work and wondering if someone can help put it right.

My CboFromState = 1 and CboToState = 2 but each time I parse this code, it skips to the End If instead of doing what I want it to do if values are found in both CboFromState and CboToState.

ElseIf IsNull((Me.CboFromState) = False) And IsNull((Me.CboToState) = False) = True Then 'DATA FOUND IN BOTH FROM AND TO STATE

Any help much appreciated.
CF

Boolean IsNull Syntax Issue

Microsoft Access is a rapid application development (RAD) relational database tool. Access can be used for both desktop and web-based applications, and uses VBA (Visual Basic for Applications) as its coding language.