How do I check if recordset exist?

S

Sunny

I want to close recordset before exiting from form id any. How do I check
whether recordset is exist or not?

Thanks.
 
J

John Nurick

Hi Sunny,

I wouldn't bother checking, I'd just try to close it and ignore the
error this may raise:

Dim rsR as Recordset

...

On Error Resume Next
rsR.Close
On Error Goto 0
Set rsR = Nothing
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Adding new records via recordset 4
A theoretical question: how best to manage perpetual recordset needs? 25
recordset vs collection 2
Append Access Table, delete transferred records, and keep "duplica 4
Dim rs as recordset or object? How to check if an rs is open? 39
ADO retrieval from close workbook-data type issue 2
use recordset as source for form 16
How to read a Recordset into a table/form/report? 1

Top