Logo Questions Linux Laravel Mysql Ubuntu Git Menu
 

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?

like image 965
dmr Avatar asked Mar 02 '10 20:03

dmr


1 Answers

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.

like image 137
Fionnuala Avatar answered Oct 21 '22 04:10

Fionnuala