I've found a few sites about paging recordsets in ASP as well as the thread on this board and I have used so many examples on how to page through records. I keep getting the same problem. I have a search and when the search returns the results on the 2nd page, you see the first 5 results of the query. Good. But when I click on the first/previous/next/last buttons, it navigates the 5 records through ALL the records and not just the results from the query. Any tips or suggestions where my error could be, would be very helpful. Thanks.

No very clear to your question. What does it mean?

"it navigates the 5 records through ALL the records and not just the results from the query."

Maybe the criteria used in the first (good) SQL statement needs to be saved in session variables for future use.

Sorry, I'll try to explain it better:

I have a search and results come up. Let's say there are 830 records in my database and my search brings up 40. So my results page displays the first 5 of the 40. When I click "next", it displays the second set of 5 out of my 830 records.

Check if you are passing the search criteria when you click "Next".

For example if your search begins at a form with a textbox called SearchBox and you are passing the criteria through a querystring your URL should have something like ?SearchBox=MySearchTerm at the end of it, make sure that when you click on "Next" you are passing the querystring in the URL for "Next".

Okay I got it working! I used a hidden field to pass my sql query and made sure all my links submittied. Thanks!

Is there any function in vb script that helps us to checks that
the input entered in textbox is Alpha
Plz

There is no specific function in VB Script to check if the input is alphabetic string, but you can create one or you can use JavaScript to check the input on the client browser.