"Bobbo" <> wrote in message
news: oups.com...
>
> roger wrote:
>
> > "Generally, when you use Set to assign an object reference to a
variable, no
> > copy of the object is created for that variable. Instead, a reference to
the
> > object is created. More than one object variable can refer to the same
> > object. Because these variables are references to (rather than copies
of)
> > the object, any change in the object is reflected in all variables that
> > refer to it."
> >
>
> I guess that's why these things have .clone() methods (see ADO
> recordset). Except in this case, where it would be useful. 
>
I've not seen any objects in common use that have clone method of the type
desired by the OP.
The clone method of a recordset allow a new filter and seek position to be
created independant of the orginal recordset object. However the underlying
data remains the same if you change the data in one the changes are visible
in the other.