Access multiple options in VBA- Access

E

Elflord

Joined
May 26, 2010
Messages
2
Reaction score
0
Please help if you can!

I have a chance to create a "multilevel" if then statement but it doesn't like the words 'OR' or 'And' in an if then else statement.

I have tried to enter it as

If RTrim(txtUSML) = "NLR" Or RTrim(txtUSML) = "EAR*" Or RTrim(txtUKEU) = "NLR" Or RTrim(txtUSML) = "EAR 99" Then [txtExport] = "These goods are No License Required and not subject to Export Regultation" Else End

Any ideas why it doesn't like And or OR?

thanks
 
Back
Top