View Full Version : Next Record


lorenzoaj
08-12-2002, 03:21 PM
Hello all.

I used the wizard to create command buttons next record and previous record. Is there a way when it gets to the last record to go to the first record? Thanks in advance to anyone who can help point me in the right direction.

AJ

chrismcbride
08-12-2002, 05:58 PM
This ought to do it...

If Me.CurrentRecord = Me.RecordsetClone.recordCount Then
DoCmd.GoToRecord , , acFirst
Else
DoCmd.GoToRecord , , acNext
End If

HTH
Chris