How to detect then existence of an object (a recordset actually)
Posted on 2003-02-20
I would like to create a new recordset (RS) upon changes of a particular value (say Val). But before this, there might be another old RS created. So, before I can recreate RS, I need to detect the existence of any open RS, destroy it and create a new one with different values (but using the same object name which is "RS").
How should I detect the existence of RS? Or perhaps there is any other better option to solve this problem.