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
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