Has object been set?

Code:

---

Static myDb As Database, myRs As Recordset
Set myDb = whatever
Set myRs = whatever

---

Now, when I enter this procedure, I want to find out if the recordset has been set already. If not, I want to set it. If so, I want to do some stuff with it. Basically, we're talkin' persistent recordsets. That's possible, right?

I thought I could put a

Code:

---

If myRs = Nothing Then

---

in before the Set myRs statement, but that would be too easy, so how?

The point of all this (if you're at all interested) is that I want to create an RS when the user loads the form, consisting of, say 50 records. There is a drop down on the form where they can select a filter of that RS. So I want to load the whole thing first time, but set a filter on the existing RS (which is a random sample of the full database) on subsequent calls.

:confused:

If myrs IS Nothing Then

try this :

VB Code:

If myRs Is Nothing Then

Thanks people. God, I suck :D

Static Recordsets.... what is the world coming to? :D

- gaffa

I know!

Seemed like a good idea at the time :p