- Joined
- May 20, 2011
- Messages
- 2
- Reaction score
- 0
Hello,
I have multiple forms that I would like to open one after the another. I can build a Next button on each form and will add a macro to specify the next form to be displayed. However this method is easy to implement when there are few forms to display in the sequence. But if I have multiple forms to display one after the other, I think this method is not efficient because if I have to add any form in the existing sequence than I will have to change the entire sequence.
Is there a way through an external macro or a VBA code that I can specify at the run time the next form to be displayed?
Thanks for your help.
I have multiple forms that I would like to open one after the another. I can build a Next button on each form and will add a macro to specify the next form to be displayed. However this method is easy to implement when there are few forms to display in the sequence. But if I have multiple forms to display one after the other, I think this method is not efficient because if I have to add any form in the existing sequence than I will have to change the entire sequence.
Is there a way through an external macro or a VBA code that I can specify at the run time the next form to be displayed?
Thanks for your help.