Duplicate / Copy / Clone Recordset (A2K)

[Schof]

Can someone remind me how to create a copy of a form's current record (or recordset) without maintaining the reference to the underlying table? Basically I want to copy the current record before deleting it so I can reference some of the field values afterwards in order to perform other operations.

I have tried the following but the recordsets become empty after deleting the current record.

dim rst as dao.recordset

set rst = Me.Recordset.Clone
set rst = Me.Form.RecordsetClone
set rst = Me.Form.Recordset.OpenRecordset

 

[danvlas]

You could use the Delete event to store the values in the fields in variables/array.

HTH



Daniel Vlas
Systems Consultant

http://www.geocities.com/danvlas/AutoMail.html

 

[Schof]

There has to be an easier way than that...

 

[Schof]

...and there is:

Set rst = Me.RecordsetClone


So close and yet, so far.

 

[danvlas]

It still loses the record after deleting it...






Daniel Vlas
Systems Consultant

http://www.geocities.com/danvlas/AutoMail.html

 

[Schof]

So I found out . Still looking...

 

[Schof]

But this seems to work...

Me.Recordset.OpenRecordset