The Missing Gun (2002)

After a policeman gets drunk and loses his service weapon, he frantically searches for his revolver and the killer who murdered his former lover.