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

 

[salad]

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.