vba - Why clone an MS-Access recordset?

Question

asked Oct 24, 2021 in Technique[技术] by 深蓝 (71.8m points)

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?

See Question&Answers more detail:os

与恶龙缠斗过久,自身亦成为恶龙；凝视深渊过久,深渊将回以凝视…

2.0k views

1 Answer

深蓝 · Answer 1 · 2021-10-23T21:43:05+0000

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.