Middle record in a form

[John]

Hi

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

Thanks

Regards

[Arvin Meyer [MVP]]

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

"John" <Jo**@nospam.infovis.co.uk> wrote in message
news:#z**************@TK2MSFTNGP15.phx.gbl...

Hi

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

Thanks

Regards

[salad]

John wrote:

Hi

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

Thanks

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.