Clone Method (ADO)

   Example   Applies To   

Creates a duplicate Recordset object from an existing Recordset object. Optionally, specifies that the clone be read-only.

Syntax

Set rstDuplicate = rstOriginal.Clone (LockType)

Return Value

Returns a Recordset object reference.

Parameters

rstDuplicate   An object variable identifying the duplicate Recordset object you're creating.

rstOriginal   An object variable identifying the Recordset object you want to duplicate.

LockType   Optional. A LockTypeEnum value that specifies either the lock type of the original Recordset, or a read-only Recordset.

Constant Description
adLockUnspecified Default. The clone is created with the same lock type as the original.
adLockReadOnly The clone is created as read-only.

Remarks

Use the Clone method to create multiple, duplicate Recordset objects, particularly if you want to be able to maintain more than one current record in a given set of records. Using the Clone method is more efficient than creating and opening a new Recordset object with the same definition as the original.

The current record of a newly created clone is set to the first record.

Changes you make to one Recordset object are visible in all of its clones regardless of cursor type. However, once you execute Requery on the original Recordset, the clones will no longer be synchronized to the original.

Closing the original Recordset does not close its copies; closing a copy does not close the original or any of the other copies.

You can only clone a Recordset object that supports bookmarks. Bookmark values are interchangeable; that is, a bookmark reference from one Recordset object refers to the same record in any of its clones.