query a DB - pass the query to next page

[cooldv]

I am running a querry on an access database and have set the number of
records/page displayed at 20. if there are more than 20 records
returned, then 1st page will show the first 20, the next page will
show next 20 and so on....

The trouble:
the count of total records displayed is correct and the first page is
displayed correctly. But when i click on *Next* to go to the next
page, all the records of the database get displayed (not the 2nd page
of records from the query).

here is the demo i put up: http://www.as.pgims.org/query/query.asp

Any help?

 

[Aaron Bertrand [MVP]]

www.aspfaq.com/2120