Middle record in a form

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

John - 27 Feb 2006 02:40 GMT

Hi

Is it possible to somehow jump to the approximate middle record on a form
via code?

Thanks

Regards

Reply to this Message

Arvin Meyer [MVP] - 27 Feb 2006 02:49 GMT

Just a guess, but if you dim a variable and set it = to the form's
recordsetclone.recordcount then divide that recordcount in half. You could
then loop through half of them, find the record's ID then move to that
record. Seems like a lot of work though.
--
Arvin Meyer, MCP, MVP
Microsoft Access
Free Access downloads
http://www.datastrat.com
http://www.mvps.org/access

> Hi
>
[quoted text clipped - 4 lines]
>
> Regards

Reply to this Message

salad - 27 Feb 2006 05:17 GMT

> Hi
>
[quoted text clipped - 4 lines]
>
> Regards

It could be done in code. If the form has navigation buttons, you can
enter the record number to jump to. If the record is 1 of 10 records,
you can enter 5 and go to the 5th record.

Reply to this Message