• Create BookmarkCreate Bookmark
  • Create Note or TagCreate Note or Tag
  • PrintPrint
Share this Page URL
Help

16. Programming DAO: Data Manipulation L... > 16.3. Moving Through a Recordset

Moving Through a Recordset

All recordsets have a current position (pointed to by the current record pointer) and a current record. Normally, the current record is the record at the current position. However, there are two exceptions. The current position can be:

  • Before the first record

  • After the last record

in which cases there is no current record.

To change the current position (and hence the current record), Jet provides several Move methods:

MoveFirst

Moves to the first record.

MoveLast

Moves to the last record.

MoveNext

Moves to the next record.

MovePrevious

Moves to the previous record.

Move[n]

Moves forward or backward n positions.

In each case the syntax has the form:

RecordSetVar.MoveCommand

PREVIEW

                                                                          

Not a subscriber?

Start A Free Trial


  
  • Creative Edge
  • Create BookmarkCreate Bookmark
  • Create Note or TagCreate Note or Tag
  • PrintPrint