Kids in the Hall: Brain Candy(1996)

Synopsis

A pharmaceutical scientist creates a pill that makes people remember their happiest memory, and although it's successful, it has unfortunate side effects.