i cant remember the title of a movie

So ive been thinking lately about a movie i saw a long time ago in the 90's.
The plot was something like this.. Theres a cop investigating a case. The case somehow involves a healthy woman. (i think her husband was murdered or missing). Anyways the movie ends up this cop going to this woman's house one night after he went to the pharmacy earlier that day. He ends up taking this woman to her bedroom because he found her asleep. But ends up having sex with her.

Can someone tell me the name of this movie please. I would appreciate it a lot.