Zydeceltico
Registered User.
- Local time
- Today, 08:15
- Joined
- Dec 5, 2017
- Messages
- 843
Hi All -
I have 3 forms: Form1, Form2, and Form3.
Form1 and Form2 each have a button to open Form3.
Form1 and Form2 cannot be open at the same time.
It is not always necessary to open Form3. But sometimes it is and when it is necessary, Form3 needs to acquire the name of whichever Form (1 or 2) opened it.
How do I do this? There are actually 5+ forms that could call Form3.
I'm guessing a variable of some nature but I am really a novice with VBA so clarity and detail really helps.
I should add that when Form1 or Form2 calls Form3, the calling Form is still open and does not close until a "Save" button is clicked on Form3 at which point the calling Form and Form3 are both saved to table.
Thanks!
Tim
I have 3 forms: Form1, Form2, and Form3.
Form1 and Form2 each have a button to open Form3.
Form1 and Form2 cannot be open at the same time.
It is not always necessary to open Form3. But sometimes it is and when it is necessary, Form3 needs to acquire the name of whichever Form (1 or 2) opened it.
How do I do this? There are actually 5+ forms that could call Form3.
I'm guessing a variable of some nature but I am really a novice with VBA so clarity and detail really helps.
I should add that when Form1 or Form2 calls Form3, the calling Form is still open and does not close until a "Save" button is clicked on Form3 at which point the calling Form and Form3 are both saved to table.
Thanks!
Tim