How to display first 15 records only on form

[Paul]

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

 

[Jeff Boyce]

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

 

[John Vinson]

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]