How to tell is a DAO recordset is open 2

[Weebairnes]

Attempting to close gives an error. Is there an easy way to tell if a DAO recordset is open?

thanks

 

[PHV]

Something like this ?
If Not myRS = Nothing Then myRS.Close
Any way the following code should close the recordset:
Set myRS = Nothing

Hope This Help, PH.
Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884 or FAQ222-2244

 

[LittleSmudge]

or the heavy handed approach :-

On Error Resume Next
myRS.Close
On Error Goto UsualErrorHandler


Old Family Motto:-
Never use a tin tack when a 6" nail will do.



G LS
spsinkNOJUNK@yahoo.co.uk
Remove the NOJUNK to use.