Originally posted by kleinma
well why do you have

On Error Resume Next

inside your error handle.. shouldn't that go at the top of your sub/function?

also you can use

rsRes.State to determine the open/closed state of a recordset or connection (cnnCon.State)... it will return either a 0 or 1 for closed or open.
I only want to resume on an error within the error handler.
I'll sort (hopefully) all errors within it.
but now, thanks to you I know how to check if the rs is open, so I'll not need it.
Cheers.