Loose Cannons (1990)
Loose Cannons is a 1990 comedy film, written by Richard Matheson, Richard Christian Matheson, and Bob Clark, who also directed the film. The film is about a hard-nosed cop who is teamed up with a detective with multiple-personality disorder to uncover a long-lost Nazi sex tape, featuring Adolf Hitler, which would jeopardize the political future of the German chancellor-elect.
More at Wikipedia.