Has object been set?

[mpgalvin]

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

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.

[stevess]

If myrs IS Nothing Then

[crptcblade]

try this :

If myRs Is Nothing Then

[mpgalvin]

Thanks people. God, I suck

[gaffa]

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

- gaffa

[mpgalvin]

I know!

Seemed like a good idea at the time