Kids in the Hall: Brain Candy (1996)

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