Hello,
Much is possible when writing code. However I do not agree with your comment.
First, the selection is identical to your initial form - still a large list
. So it seems if this modified form is confusing than so is your approach. They are both the same. It is just that you use two forms and code and this uses one form and no code. The grid has the next and previous buttons on there.
Don’t see the confusion but you can always use separate buttons assigned to Previous
and Next
actions (place on main form with grid).
Best part is no need for macros. Best to avoid whenever possible.