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
Printable View
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
VB Code:
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
hi,
if rs.state=1 then rs.close