What's the difference between Recordset.MoveNext and GoToRecod, ac

A

Adam Thwaites

What's the difference between
Me.Recordset.MoveNext
and
DoCmd.GoToRecord , , acNext
and which is best to use?

Cheers
 
A

Allen Browne

The best one might be:
RunCommand acCmdRecordsGoToNext

IME, using the form's Recordset is more flakey, and won't work with older
versions. The RunCommand above is functionally equivalent to your DoCmd.

A key difference is that the RunCommand/DoCmd works on whatever form is
active, whereas the Recordset move applies to a specific form (whether
active or not.)
 
Top