[AccessD] Error on Next Record

Mike,

I just trap for 2105 and bail out of the sub when encountered.
Something like:

On Error Goto ErrorHandle

 . . .  Navigation Code Here  . . .

SubExit:
  Exit Sub

ErrorHandle:
  Select Case Err.Number
    Case 2105 'Nuisance error - ignore it
    Case Else
      Msgbox Err.Number & " " & Err.Description
  End Select
  Resume SubExit

Hope this helps.

Don

-----Original Message-----
From: Gowey Mike W [mailto:Mike.W.Gowey at doc.state.or.us] 
Sent: Tuesday, June 10, 2003 8:02 AM
To: accessd at databaseadvisors.com
Subject: [AccessD] Error on Next Record



Hello Everyone,


Does someone possibly know how I can get rid of the following runtime
error?

Runtime error '2105
You can't go to the specified record.


I have a form that I use a query to extract certain information from a
Linked Oracle table.  I have buttons on the form for the user to go to
next and previous records.  When ever they reach the first record and
press the previous button again this error comes up and if they reach
the last record and press the next button again the error also comes up.

Is there anyway to make this error not show and just stay on the current
record??  I don't want the user to have to answer the question to be
able to continue.

Mike Gowey, MCP
Technical Support Analyst
SRCI ISSD Team Leader


_______________________________________________
AccessD mailing list
AccessD at databaseadvisors.com
http://databaseadvisors.com/mailman/listinfo/accessd
Website: http://www.databaseadvisors.com