Next Record (1 Viewer)

[lorenzoaj]

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]

This ought to do it...

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

HTH
Chris