I am working with two asp pages, Page1.asp and Page2.asp

On page1.asp I have a listbox... when I select an item it will POST the value to Page2.asp...

The value is then passed into a query:

sql = "SELECT * FROM Table1 WHERE Number = " & Record
oRS.Open sql, oConn,1,3

With this data it populates the text boxes... this work perfectly...


I want to be able to Navigate through the recordset I queried by using a Next and a Previous button while populating the text boxes with the new values...


I am using an Access 2000 database.....

Can anyone help me out?