As others have said. A new door locking module is what you need. Such a common problem with these cars
It's an easy enough job IF you can get the poxy door to open!!
I just couldn't get mine to open, no mater what I did!! Tried all the tricks.
Even tried removing the door skin without opening the door!! Needless to say that was a total waste of time
Supposedly it can be done (on a 5 door car) but I couldn't manage it
I was getting ready to cut the door skin with my angle grinder and looking at replacing the door skin, door lock, then body shop for paint (most likely in a slightly different shade of red
) etc etc...
To say I was miffed would be an understatement....
But before I got the angle grinder out I popped down to my local Auto electricians (who have a seriously good reputation!!) to ask their advice.
The senior technician there was able to pop my passenger door grab handle off and access the door lock wiring loom. He put 24 volts across the lock and blew it to smithereens!
I was delighted as the door could now be opened and the module swapped out!!
No great drama, no angle grinder and no poxy trip to the paint shop
Anyways just thought I would share that story
Hopefully yours will be much much more straightforward