There was a movie I saw some years back and it was about all these people that were all sex-crazy after being hit in the head and then going back to normal when hit in the head again.

Try A Dirty Shame

Shallow Harold