Quote Originally Posted by pame1la
but it doesnt let me open the rs, comes up with that error!!! i can only check the state if its open rite?!
Guessing that you got an error on the SQL side then - so no RS at all...

So check

Code:
If rs is Nothing Then
   MsgBox "Got no RS"
End if