[AccessD] Calling control (WAS How do I determine which form called?)

This is interesting. I need to do something sort of similar... I have an
unbound text box on an unbound form which I want to use to display memo
fields that are too small to display all their data in the controls on my
main forms. To get the data out is easy - screen.activecontrol will do it.
But then if they amend the data I need to get the new string back into the
right control on the right form. Trouble is it could be up to 3 layers deep
on subforms and as far as I can tell, to get the data back in I need to
build a full reference to the calling control e.g.
Forms!frmLevel1!frmLevel2.form!frmLevel3.form!ctrlCalling
 
Does anyone have an idea of how I could do this when I don't know how many
forms are involved???
 
TIA
 
Roz
 
-----Original Message-----
From: Charlotte Foust [mailto:cfoust at infostatsystems.com] 
Sent: 30 June 2003 18:13
To: Access Developers discussion and problem solving
Subject: RE: [AccessD] How do I determine which form called?
 
I make CalledFrom a property of my forms.  Then I can pass the calling
form's name in the OpenArgs string and let the called form populate its own
property.  When I close the called form, it checks its CalledFrom property
and goes back to that.  In 2002 you can do this with Reports as well.
 
Charlotte Foust
-----Original Message-----
From: Hale, Jim [mailto:jim.hale at fleetpride.com] 
Sent: Monday, June 30, 2003 6:04 AM
To: 'Access DatabaseAdvisors (E-Mail)'
Subject: [AccessD] How do I determine which form called?
Does anyone have a function that will allow a class to determine which form
called it? TIA 
Jim Hale 
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://databaseadvisors.com/pipermail/accessd/attachments/20030701/ae39ebb1/attachment.html>