She's The One.

Two young burglars break into DI Carter's house and steal his illegally held replica Colt 45 pistol, leaving everyone involved in hot water. Meanwhile, Colin is drawn into a couple's kinky fantasies while on a surveillance operation.