Hello again,

I have a table (tasks) containing hundreds of records and I would like
my form (task_list) only to display 15 records at a time (starting with
the first 15 in the table). Then when the user clicks on 'next' I would
like the next 15 records to appear. I would also like a 'previous'
button that returns to the previous 15 records.

Is this possible? And if so please can somebody help me?

Many thanks in advance.

P

Paul

"The first 15 in the table" is an oxymoron. Access stores records in tables
according to its own needs and plans, not yours.

That said, you can still get at an ordered/sorted set of records by using a
query, and telling Access how to sort them.

To implement the "15-at-a-time", you could create a procedure that tracks
how many have been shown and where to start and stop ... a somewhat complex
effort.

Or you could use a listbox that shows 15 rows, and let the user click in the
scroll bar to jump up and down 15 at a time.

Regards

Jeff Boyce
Microsoft Office/Access MVP

"Paul" <(E-Mail Removed)> wrote in message
news:(E-Mail Removed)...
> Hello again,
>
> I have a table (tasks) containing hundreds of records and I would like
> my form (task_list) only to display 15 records at a time (starting with
> the first 15 in the table). Then when the user clicks on 'next' I would
> like the next 15 records to appear. I would also like a 'previous'
> button that returns to the previous 15 records.
>
> Is this possible? And if so please can somebody help me?
>
> Many thanks in advance.
>
> P
>

On 17 Jan 2007 01:45:25 -0800, "Paul" <(E-Mail Removed)>
wrote:

>Hello again,
>
>I have a table (tasks) containing hundreds of records and I would like
>my form (task_list) only to display 15 records at a time (starting with
>the first 15 in the table). Then when the user clicks on 'next' I would
>like the next 15 records to appear. I would also like a 'previous'
>button that returns to the previous 15 records.
>
>Is this possible? And if so please can somebody help me?
>
>Many thanks in advance.
>
>P

The simplest way would be to use a Continuous Form with room for 15
rows, and let the user click on the very standard navigation controls
(scrollbar, or the page up/page down keys). No code at all...

John W. Vinson[MVP]