recordset clone method

[vientito]

Executing a recordset.clone method will create a clone. Could this cloned recordset be used for editing the underlying records as well, just like the original?

If I use a recordset without explicitly calling openrecordset (e.g. just use what it is that I get when the form loads) I know it is not my responsibility to close it.

On the other hand, the cloned recordset has to be explicitly closed by me, right?

Closing one recordset will not affect the other subsequent operation, I suppose?

[June7]

Yes, the clone can be used to edit records.

It is possible to manipulate the clone without creating recordset object. Example:

With Me.RecordsetClone
.Edit
.Division = "LLSB"
.Update
End With

I think Recordset objects are supposed to automatically close and the variables clear when procedure finishes but is good practice to explicitly close and set variable to nothing.