This example creates a Recordset object based on the Orders table in the Northwind database and uses the Clone method to create two more Recordset objects. Each Recordset object has its own current record that can be moved independently of the other.
See How to Build the DAO Method Samples.
On the MSDN Library discIf you have installed the DAO SDK, see Samples\dbdaoInstallDirectory\DAOSDK\SAMPLES\Clone.cpp.