Locate recordset

[cumap]

Hello all,

I'm creating a admin page to edit/add recordsets from an Access db and I'd like to be able to have 2 links: goto Next and Previous recordset on a current editing recordset page. I wonder that whether I can/cannot pinpoint the current recordset, then assigning the Pinpoint +1 to Next and Pinpoint-1 to Previous recordset, do you think it could work? if so, how can I pinpoint the record anyway?

Here is a script to call for recordset in the page:

Set rstCat = Server.CreateObject("ADODB.Recordset") 
rstCat.CursorType = 2 
rstCat.LockType = 3 
rstCat.Open "SELECT * FROM Categories WHERE id = " & id, dbConn, , , adCmdText

Thanks!

 

[PHV]

Have a look at the BOF and EOF properties, and the MoveNext and MovePrevious methods.

Hope This Helps, PH.
FAQ219-2884
FAQ181-2886

 

[cumap]

I've thought and tried the MoveNext/MovePrevious but don't know how to have the buttons/links to call the functions