Hey All,
Thanks for your help, couldnt find any info on how to send multiple strings to check in an IF AND THEN statement.
Am trying to do an action only when a person is a certain ROLE and a certain LOCATION.
so...this is what i have however everything is coming back with the "It worked" Msgbox and i cannot get anything to throw the "Computer says no" error message.
Could somone lend a hand?
Thanks
if (($role = "1" OR "2" OR "3" OR "4" OR "5" OR "6" OR "7" OR "8") and ($loc ="Mackay" OR "MBH" OR "Royal Child" OR "RCH" OR "CBH" OR "Cairns" OR "CH")) then
MsgBox(0,"WOOHOO","It worked")
Else
MsgBox(0,"BOWBOWWWW","Computer says nooo")
EndIf