You're thinking of The Rocky Horror Picture Show, released in 1975.
It wasn't actually a huge hit at the time, but it found a cult following through midnight screenings and word-of-mouth. Today, it's considered a classic and a must-see for fans of campy, quirky horror-comedy musicals.