can't go to specified record help

I

Ian

Hi,

While doing

DoCmd.GoToRecord , , acNext

If get the above message how can i stop the message from
appearing

Thanks

Ian
 
J

John Vinson

Hi,

While doing

DoCmd.GoToRecord , , acNext

If get the above message how can i stop the message from
appearing

By not doing it unless there *is* a next record:

If Me.EOF Then
<do whatever you want done if the user is at the last record>
Else
DoCmd.GoToRecord , , acNext
End If
 

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

Top