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.