I have a subform, using datasheet view, with a list of names (several hundred)
When I do a find, say "Smith", it moves to the first smith. I go to find again, and it goes to the second smith.
The problem is I would like the record that was found to always be displayed at the top of the datasheet view, so the user can easily see it, however access shows it as the last record on the list.
I probably could filter based on criteria to shorten the list, be ideally, I would like it just to move the position (vertical scroll) up to the top.
Thanks in advance!
When I do a find, say "Smith", it moves to the first smith. I go to find again, and it goes to the second smith.
The problem is I would like the record that was found to always be displayed at the top of the datasheet view, so the user can easily see it, however access shows it as the last record on the list.
I probably could filter based on criteria to shorten the list, be ideally, I would like it just to move the position (vertical scroll) up to the top.
Thanks in advance!
