[AccessD] Error on Next Record

Mike,

I have a slightly long winded approach to this I'm sure someone has a better solution, when I open a form I disable the previous button as the user will be on the first record anyway, and when the user moves off the record I enable it.  If they click the previous button, after the actual record move I see if it is the first record, if it is I disable the previous button again.  I do a similar procedure with the user hitting the last record where I disable the next button if tha last record is reached.....

Paul


From: "Gowey Mike W" <Mike.W.Gowey at doc.state.or.us>
Date: Tue 10/Jun/2003 15:01 GMT
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


__________________________________________________________________________
Join Freeserve http://www.freeserve.com/time/

Winner of the 2003 Internet Service Providers' Association awards for Best Unmetered ISP and Best Consumer Application.