OR Statement??

[B-Dog]

This has to be really simple but I can't figure it out. I'm trying to check
to make sure the dataset in not null and a single character string doesn't
equal two characters. I want it to stop if it is null and stop if the
string doesn't equal i or or? If either one is true then run sub. What am
I doing wrong

If dr Is Nothing OrEsle inOut <> "i" Or "o" Then

'bad filename

lstEvents.Items.RemoveAt(0)

Exit Do

End If

 

[Ken Dopierala Jr.]

Hi,

Try:

If ((dr Is Nothing) OrEsle ((inOut <> "i") AND (inOut <> "o"))) Then

Good luck! Ken.

 

[Think_Fast]

If dr Is Nothing OrElse inOut <> "i" Or inOut <> "o" Then

 

[B-Dog]

Thanks guys that worked, simple thing had me going.

 

[Shawn B.]

Shouldn't that read:

If ((dr Is Nothing) OrElse ((inOut <> "i") AndAlso (inOut <> "o"))) Then

Just to be optimal..

Thanks,
Shawn

 

[B-Dog]

Worked but I will try you way also. Thanks

Shouldn't that read:

If ((dr Is Nothing) OrElse ((inOut <> "i") AndAlso (inOut <> "o"))) Then

Just to be optimal..

Thanks,
Shawn