Hi,

I have been trying to implement recordset paging for a site. I have tried about 10 different tutorials unsuccessfully and I really am stuck.

The problem i seem to have is that all the examples are based on really simple queries i.e SELECT * from tblName. But i am trying to do it with this query:
-------------
If(Status = "both) then Status = "LIKE '%%'" Else Status = "= '" & Status & "'"

sSQL = "SELECT * FROM tblProperty WHERE Status " & Status & " AND (Beds >= " & beds & ") AND (price >= " & minprice & " AND price <= " & maxprice & ") "& QueryType &" "& QueryArea &" ORDER BY price ASC"
------------
I have managed to get the first 10 results to display ok, but when i try and go to the proceeding pages I always get query errors, I'm guessing this is because I need to pass the search variable between the pages???

You can see my efforts here:

search page - http://www.signaturehomesoverseas.com/searchtest.asp

I'm really struggling with this and need to get it done as asap, what I would like to know, is their any simple alternatives to recordset paging?

Any help would be greatly appreciated. Thanks