Dreamaniac (1986)

A heavy-metal musician makes a deal with a satanic succubus to make him successful with women, in return for the succubus being able to feed on the girls.