Hi,
I have 3 forms calling the 4th one. How can I tell from that 4th form wich one of the first 3 called it. I mean something like me.parent.name (wich doesn't exists ofcourse). Thank you!
I'm not aware of a direct way of doing it. In the absence of such, I would declare a public variable "CurrentForm", and a local variable "ParentForm" in each of your forms, then put in the userform.activate for each form:
ParentForm=CurrentForm
CurrentForm=me.name
and put in the userform.terminate for each form:
CurrentForm=ParentForm
I haven't actually tried this, but I don't see why it wouldn't work, and it's not too much trouble...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.