Check For Open Recordset

[JCScoobyRS]

I need to be able to check for an open recordset. If one is open, close it, if not, End if. Can someone help? Thanks, Jeremy

[SkiNLaB]

if rst.state = adstateopen then
         'recordset is open
end if
if rst.state = adstateclosed then
         'recordset is closed
end if

or it might be adopenstate and adclosedstate i cant remember

[jayakumar]

hi,

if rs.state=1 then rs.close