为什么要克隆MS-Access记录集?

为什么要克隆MS-Access记录集?

问题描述:

我是VBA的新手,正试图了解别人的代码.

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

设置rstClone = Me.RecordsetClone
rstClone.MoveFirst

Set rstClone = Me.RecordsetClone
rstClone.MoveFirst

为什么必须克隆记录集?为什么代码不能是Me.Recordset.MoveFirst?

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

您可能希望使用recordsetclone,因为您不希望影响me.recordset.movefirst会在表单中显示的记录.

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.