ASP SQL Paging

I was wondering if any body can kindly help me with a little dilemma I have.
ASP and SQL paging was relatively easy to implement, however, I cannot manage to get start the paging from a certain record:

In the script that I made, about 4,000 pictures get displayed as thumbnails in paged view, when users click on a thumbnail they are taken to individual picture view, with “next” and “back” controls, however, I cannot find a way of returning the user to the thumbnail view that starts with the picture they just viewed, and not the beginning of the recordset.