LOOPING records from to the end to the top?

[Post=16088 sal21]

I think....

When i loop in recorset with rs.eof the code read from the top to the end of list, or not?
If yes, how to loop in recordset from the end to the top of list, is this possible?

[HansV]

To loop backwards, you need to open a recordset with the adOpenKeyset option; by default, a recordset will be opened with adOpenForwardOnly.

Here is some sample code, using a connection cnn and a recordset rst:

Code: Select all

' Open recordset (I assume the connection has already been opened)
rst.Open "MyTable", cnn, adOpenKeyset, adLockOptimistic, adCmdTableDirect
' Go to the last record in the recordset
rst.MoveLast
' Loop until you're at the beginning
Do While Not rst.BOF
  ' Your code here
  ...
  ' Go to the previous record
  rst.MovePrevious
Loop
' Close the recordset
rst.Close
Set rst = Nothing