It's Punky Brewster

Caught in the Act (2x16)

:

Henry spots Glomer raiding the refrigerator. In his panic, Glomer casts a spell giving Henry amnesia. Poor timing as Henry is due for an important photography job. Glomer concocts an antidote but it makes Henry think he's an Indy 500 race car driver, a football quarterback, and a rock star.