I have created a form that is being shared by 8 reviewers. I want to load 1000 cases into the table that drives the form and when a reviewer logs into the form, they can click on a “Find Next” button and it will take them to the an uncompleted record. They would then assign the case to themselves and complete it. Then Click "Find Next" and it would go to the next uncompleted case.
I have tried writing Macros and assigning it to a button but I just haven't found the magic formula yet. I am fairly new to building applications so I would appreciate a step by step answer.