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 (http://en.wikipedia.org/wiki/A_Dirty_Shame)

Shallow Harold