Add Code to Move through the Displayed Recordset (RDS)

You can use the Move methods with the Recordset in the RDS.DataControl object to navigate through the data records displayed in the data-bound controls on a Web page. For example, suppose you display a Recordset in a grid by binding to an RDS.DataControl object. You can then include First, Last, Next, and Previous buttons that users can click to move to the first, last, next, or previous record in the displayed Recordset. You do this by calling the MoveFirst, MoveLast, MoveNext, and MovePrevious methods of the RDS.DataControl object in the OnClick procedures for the First, Last, Next, and Previous buttons, respectively.

Search for the words "Tutorial: Move Through the Displayed Recordset." Copy the following script and paste it under the comment.

SUB First_OnClick
   ADC.Recordset.MoveFirst
END SUB

SUB Next_OnClick
   If ADC.Recordset.EOF Then   'cannot move beyond bottom record
      ADC.Recordset.MoveFirst 
      Exit Sub
   End If   

   ADC.Recordset.MoveNext
END SUB

SUB Prev_OnClick
   If ADC.Recordset.BOF Then   'cannot move beyond top record
      ADC.Recorset.MoveFirst   'Get out of BOF buffer
      ADC.Recordset.MoveLast
      Exit Sub
   End If
   ADC.Recordset.MovePrevious
END SUB

SUB Last_OnClick
   ADC.Recordset.MoveLast
END SUB

Next