I am attempting to set a validation rule against a control to prevent it from being blank unless another control equals "Instructor Substitute". Here is what i have in the rule.
PaySchedule==""&&PositionTitle!="Instructor Substitute"
Now the control name i have the rule on is PaySchedule. If I remove the section of PositionTitle, the rule functions correctly. I've checked my spelling just to make sure somewhere I've made a stupid typo. I've also tried removing the check against the control being blank and have it check on PositionTitle. That check never seems to work. For some reason, it cannot see what is actually in that control. Not sure if it matters or not, but PositionTitle is a Sql Request Control. Is there something here I'm missing?