navigation button in databaseform

<i><b>Originally posted by : Ingrid (ihei@moerdijk.nl)</b></i><br />I have a form to display records from a database. I want to make two navigation buttons to go to the next and the previous record. Can anyone please tell me how to do that?

<i><b>Originally posted by : Wen Chan (chenwen@yysoft.com)</b></i><br />U can see the SampleCode:<br /><br /><%<br />rs.pagesize = 10<br />pageno = trim(request("pageno"))<br />if isnumeric(pageno) then<br /> pageno = clng(pageno)<br /> if pageno < 1 or pageno > rs.pagecount then<br /> pageno = 1<br /> end if<br />else<br /> pageno = 1<br />end if<br /><br />if rs.recordcount > 0 then rs.absolutepage = pageno<br /><br />Sub ShowPageNavigator(pageno,despage)<br /><br /> if CLng(pageno) <= 1 then<br /> dFirst = "disabled"<br /> dPrev = "disabled"<br /> end if<br /> <br /> if CLng(pageno) >= rs.pagecount then<br /> dNext = "disabled"<br /> dLast = "disabled"<br /> end if %><br /> <br /><button type=button name=btnFirst Style="font size=9pt" onclick="window.location.href='<%=despage%>?pageno=1'" <%=dFirst%>>First</button> <br /><button type=button name=btnPrev Style="font size=9pt" onclick="window.location.href='<%=despage%>?pageno=<%=pageno-1%>'" <%=dPrev%>><br />Prev</button> <br /><button type=button name=btnNext Style="font size=9pt" onclick="window.location.href='<%=despage%>?pageno=<%=pageno+1%>'" <%=dNext%>>Next</button> <br /><button type=button name=btnLast Style="font size=9pt" onclick="window.location.href='<%=despage%>?pageno=<%=rs.pagecount%>'" <%=dLast%>>Last</button><br /><br><br /> <br /><%<br /> response.write " µÚ" & CStr(pageno) & "Page/" & CStr(rs.PageCount) & "Page"<br /> response.write "(" & CStr(rs.RecordCount) & "Record)"<br />End Sub<br />%>