How to create pagination for multiply records

[kardo]

Hi,
How to create pagination for multiply records i find some solution but i don't get the final solution
there is a query i created but it don't work
SELECT t.client_name
FROM (SELECT TOP 15 id, client_name FROM (SELECT TOP 10 id, client_name FROM dbo_contract ORDER BY client_name, id) AS foo ORDER BY client_name DESC , id DESC) AS bar INNER JOIN dbo_contract AS t ON bar.id = t.id


ORDER BY bar.client_name, bar.id;

[June7]

Why doesn't it work - error message, wrong results, nothing? What do you mean by 'pagination'? How would this occur in a query?

[kardo]

i mean in form not show all record show only 10 record and paging to show another records i searched but i don't get result.

[June7]

I've never done that. Why do you need to?

Bing search: access form pages

Get a lot of hits.

[kardo]

I want like this picture below

[June7]

Only method I am familiar with is to set the db to Overlapping Windows, then size the form to show only 10 records.

I don't know about programming buttons to navigate 'pages'. Never seen anything. That's why forms have scroll bar and what search/filter is for. How would you determine the number of 'pages'? How would you create the buttons to fit the number of 'pages'?