There was also a Police Academy movie with that plot. It was one of the later ones without Steve Gutenberg.