Search code examples
ms-accessvbaclonerecordset

Why clone an MS-Access recordset?

I'm a newbie at VBA and attempting to understand someone else's code.

Set rstClone = Me.RecordsetClone
rstClone.MoveFirst

Why does the recordset have to be cloned? Why can't the code be Me.Recordset.MoveFirst?

Solution

  • You may wish to use the recordsetclone because you do not wish to affect the records displayed in the form, which me.recordset.movefirst would do.