Since you are also experiencing issues with the power locks, and assume they work fine from the other lock switches, I'm guessing you have a broken wire or more in the multi-pin connector between the door and cabin in the door jamb. That's a pretty common problem.
-Rod