Record Selector

[Dale]

In 2003 and before you could place you mouse on the forward or backward
record selector and as long as you held it down it went forward and backward
through the records on the form. In 2007 it does not act this way. Is there a
way to get this functionality back or code to recreate this functionality?

Dale

 

[Jeff Boyce]

Dale

Actually, if your form is "loaded" with "all the records", it may have very
poor performance.

Another approach to using forms is to have a form display a single record,
and use something, perhaps a combobox, to allow the user to select which
record to display. This tends to be quite fast compared to a form that is
filled with thousands of records.

Good luck

Regards

Jeff Boyce
Microsoft Access MVP

 

[Mark Andrews]

You could always have other buttons that moved through the records previous
and next
I guess use "DoCmd.GoToRecord" and the constants for next or previous.

Of course these would have to be on the parent form or perhaps in a split
form.

I assume you can click the arrows like crazy, perhaps better to just leave
it like that
or create a listbox control next to the datasheet for navigation or a
combobox as was mentioned.

Mark