how do I move from one record to the next using buttons

[bigben]

Hi there,

I am trying to set up a simple form that is linked to a database. The form displays the current record's first name and last name from a list of names in a database. I want to include two buttons that move to next record and to previous record. Does anybody have any sample code that they can show me how to set up the code for the buttons (or they could even be hyperlinks)?

Many thanks in advance.

 

[GaryC123]

Database paging

http://www.asp101.com/samples/db_paging.asp?page=

The example is for more than one record but you only need to set the display to 1 record

http://www.intouchmedialtd.com

 

[bigben]

Thanks very much GaryC123. I also found a very good example of exactly what I wanted on the microsoft tech net site at:

http://msdn.microsoft.com/library/d...en-us/ado270/htm/mdaexamples_vbscript01_5.asp

Thanks again