error checking for DoCmd.GoToRecord acNext when it is the last record

STeve Lefevre

Hey folks --

I'm using the DoCmd.GoToRecord , , acNext to jump to the next record
after the user enters a value. The problem is, it throws an error if
it's already on the last record! What's the best way to prevent this?

Steve Lefevre

Nov 13 '05 #1

Bob Quintal

STeve Lefevre <le********@osu.edu> wrote in
news:AA*****************@fe1.columbus.rr.com:

Hey folks --

I'm using the DoCmd.GoToRecord , , acNext to jump to the next
record after the user enters a value. The problem is, it
throws an error if it's already on the last record! What's the
best way to prevent this?

Steve Lefevre

If Me.Recordset.AbsolutePosition + 1 < Me.Recordset.RecordCount
Then
DoCmd.GoToRecord , , acNext
End If

Watch the word wrap.

Bob Quintal

Nov 13 '05 #2