I was rewatching “The Silence of the Lambs” and noticed the police officers were still using revolvers.
A quick google search says “early 90’s” as the general answer. The film was released in 1991 so it’s probably one of the last major films released to show police officers armed with revolvers
I imagine there was a long transition period - big cities transitioning first and maybe rural departments taking awhile


I think in the early 90's.
Revolvers loose gas pressure where the cylinder is pushed up against the back or the barrel. They are slow to reload, and they only hold 6.
Police wanted the extra 2 bullets and the fast reloads.
The Glock's that they selected are mostly made out of very strong polymer plastic and they were put through extremely demanding qualifying trials by the Austrian military before they selected them.
FWIW, there are right wing connotations to Thomas Harris's stories. I have not read this anywhere, but I suspect that this is why Jodie Foster backed out of making any more movies based on his stories.
I had read at the time that she wanted to make Silence of the Lambs because of the strong female character.
And the newspaper applauded her because in the film someone asks her about romantic liaisons and the character declined to disclose.
Foster said she wanted to not to play these young ingénue characters, but she wanted to play more serious mature roles so that she could continue her acting career longer.
SJG