Having nearly finished a harbour booking system, I am currently tidying up the project and adding some error checking etc.

The problem is that I have a form with a data store and have previous and next buttons along with some text boxes to go through data from a database. When I use the previous and next buttons to go through the data they work fine until I go further than the last or first record. Then I get a run time eror that says that there is no current record.

How can I code some error checking that tells the person that there is no more records if they press the buttons to go further than the last record instead of having a run-time error?

Thanks in advance!