Test for valid object?

[Laurel]

Is there a way to test if a recordset variable is valid? I have these
statements just before the exit to a function, but sometimes control goes to
that point before rstClassSummaryTemp has been opened. (It's a RecordSet
variable.) In another language I would use If IsValid(rstClassSummaryTemp)
Then

rstClassSummaryTemp.Close.... etc.
rstClassSummaryTemp.Close
Set rstClassSummaryTemp = Nothing

 

[Dan Artuso]

Hi,
How about:
If Not rstClassSummaryTemp Is Nothing Then
........

 

[Laurel]

Yup, works fine. Thanks.

Hi,
How about:
If Not rstClassSummaryTemp Is Nothing Then
........