How display 12 records on a form at a time

[SteveL]

I have a subform currently that is in continuous form mode. But there will be up to 36 records to display and we don't want to display all 36 of them in one continuous form.

So I thought I would creat 3 command buttons on the main form. The first command button will display the first 12 records, the 2nd command button would display the second 12 records, and the 3rd Command button would display the third 12 records. Please note that is some cases there may be less than 36 records total so if for example there were 20 records, the button would display 12 records, the 2nd button would display 8 records and the 3rd button would display none.

Each record has a date field and the records will need to be sorted in date order.

How can I accomplish this?

 

[James Deckert]

have each button build the query you want to see in the subform, then put the query into the record source and refresh the subform.