Is it possible to make "pages" in a datasheet form? (1 Viewer)

jwaguile

Registered User.
Local time
Yesterday, 16:34
Joined
Feb 26, 2009
Messages
13
Hello!

I have a form in datasheet view, and I am wondering if it's possible to specify "pages" with a set amount of records per page.

Think like the search results of Google, you get a huge number of results, but only so many are displayed per page.

Thanks!
 

vbaInet

AWF VIP
Local time
Today, 00:34
Joined
Jan 22, 2010
Messages
26,374
I can think of two ways:

1. Using TOP to indicate the max number of records and finding the starting point of the record using a recordset. Move to that starting point from the recordset's bookmark.
2. Using a recordset to find the starting point and using TOP afterwards, then binding the recordset to the form.

My preference would be option 1.
 

Users who are viewing this thread

Top Bottom