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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Wildcards in VBA 0
Running query from Access Form commmand using VBA code 4
Error in Microsoft Encryption Sample? 2
Invalid Argument Error On A Select Query 3
Need help in printing vba code 0
ADO Recordset .Findfirst anomaly (Access 2007 ACCDB front end) 1
Access access vba multiline textbox 2
Excel [VBA] Check from a cell into another sheet and bring back result in MsgBox 0

Top