Hmmm. I'm rusty on VB but can think of a couple of possibilities. Do the input strings have the same capitalization? If not "like" or "StrComp()" might get you the answer you need.
I'm wondering if "strEventType" might have gotten declared as a variant instead of a string type (variant being the default) and if that's screwing up the comparison, but can't find a good reference to it. Try explicitly declaring it as a string if you haven't already (if you have, never mind me). Or if it's declared as a fixed-length string the trailing blanks might be screwing it up.
If that doesn't help, I'd probably put "strEventType = "Absence" " before the IF and see what happens.
no subject
I'm wondering if "strEventType" might have gotten declared as a variant instead of a string type (variant being the default) and if that's screwing up the comparison, but can't find a good reference to it. Try explicitly declaring it as a string if you haven't already (if you have, never mind me). Or if it's declared as a fixed-length string the trailing blanks might be screwing it up.
If that doesn't help, I'd probably put "strEventType = "Absence" " before the IF and see what happens.