Recordset navigation.

[Fuga]

If I have a number, how do I navigate to that row number in a recordset?

ie if i have 13, I want to go to the 13th record in a recordset.

Im using a DAO.recordset.

Fuga.

 

[ritchieroo]

You can use the Move method on the recordset to move forward or backward a number of rows from your current position. You need to make sure that your current position is the first row:

rs.MoveFirst
rs.Move 13

You can move backwards by specifying negative values.

You can use the AbsolutePosition property to check where you are:

Debug.Print rs.AbsolutePosition

Note: AbsolutePosition is zero-based so should give you 12