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

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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

Cheers
 
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.)
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Printing records on Access 2000 0
Looping until end. 2
apostrophe in record 6
Access Pop-Up Calendar 2
Last Record Error 3
Loop/Repeat Code 5
Recordset.EOF not working 5
GoToRecord in subform 1

Back
Top