Move to the First and Last Records

Moving to the first and last records of your database is a lot easier.

Double click your First button to create the code stub. Now add the
following code:

We have no need of an IF … ELSE Statement, now. The only thing we need to
do is move the Cursor to the first record with rs.First, then display
the first record in the Text Fields.

Similarly, add the following code for your Last button (you can copy and paste
the code for the First button):

The only change to make is the use of rs.Last on the first line in place of
rs.First.

When you’ve added the code, run your programme again. You should now be able
to jump to the last record in your database, and jump to the first record.

In the next part, you’ll learn how to update a record.

|