is there a way to check to see if a recordset is still a vaild object (not
already closed) before attempting to close it?

thanks

Hi,
If you want to check if it's a valid object:
If Not rsNewId Is Nothing Then

If you want to see if it's closed or not,
I beleive you have to try and close it and trap
the error if it's already closed.

Note: I assume we're talking about a DAO
recordset, not an ADO one.

HTH
Dan Artuso, MVP