I have been struggling to design a form, so that the form can be escalated from person A to person B, then person B to person C and so forth automatically. The person A only needs to click at a button (exp: confirmed?), then the form will be sent to person B. The person B will be receiving a message regarding his/her turn to view the form. Same message will be appeared for the following recipients. The recipients will be arranged by other organizer/initiator before A can view it.
I know that this sounds silly since normal operation (more tedious) can perform the same task too. I want to create more friendly system so that the users only need to click a button and it performs. I believe that M. Access is able to do this operation by using Macro. Can someone help me in developing this code? I have almost developed the form, only left with this type of escalation.
Your help is much appreciated.