| || |
mutli-select drop down list.
I have a dropdown (multi-select list). I am using list value to trigger an email. Since user can select more than 1 value, so it is hard to set up an alert.
if Bug_Fields.Field("BG_USER_14").Value = "abc" OR “production”Then
But if user selects abc;123;production or xyz;production then how can I set up an alert for that. So any time user selects value "production" I want to send an email regardless of his/her other selection from the dropdown multi-select list. Thanks for your help!
well take that value in variable , split it and validate to write your logic.
strVal = Bug_Fields.Field("BG_USER_14").Value
arrBugsOptions = split(strVal ,";")
then if and else logic
You'd be better off using instr over split otherwise you'll have to loop through an array. You also need to repeat the variable you are testing on both sides of the Or clause. I'd also suggest you read a vb tutorial or google vb string functions.