Record Navigation Help 1

[dbero]

I have a form bound to a query. On the form, I want to put a move forward/back cmd button on the form so the user may scroll through the records. for the move forward, I used the code below and it fails. Any suggestions on the code to move forward, but stop when at last record?

If Me.Recordset.EOF = True Then
Exit Sub
Else
DoCmd.GoToRecord , , acNext
End If

 

[PHV]

Perhaps something like this ?
With Me.Recordset
.MoveNext
If .EOF Then .MoveLast
End With

Hope This Helps, PH.
Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884 or FAQ181-2886

 

[dbero]

Worked great. Thanks a lot!