Sorry, but there is very little information to work with.
Does the drivers dor switch ever work? You said then meaning after you use the rear switch.
Have you taken the door panel off and made voltage measurements at the switch and motor?
Have you checked to make sure the ground at the switch and motor are good?
This could be a lot of things. I wouldn't spend money on parts until you troubleshoot some more. Could be a loose ground anywhere, could be a short between unkown wires, could be a faulty switch.
You need to get a voltmeter and make the measurements. I would start at the switch you are having problems with. First Ohm reading to check ground, then voltage before you press switch, then while pressing switch and then what is happening when the window goes back up on its own. The repeat at the motor.