[AccessD] Calling control (WAS How do I determine whichformcalled?)

LOL
 
Sorry, John.  I'm single but you're not! <VBG>
 
Charlotte Foust
	-----Original Message-----
	From: John Colby [mailto:jcolby at colbyconsulting.com] 
	Sent: Tuesday, July 01, 2003 8:17 AM
	To: Access Developers discussion and problem solving
	Subject: RE: [AccessD] Calling control (WAS How do I determine
whichformcalled?)
	
	
	Oh Charlotte, a girl after my own heart!  :-)
	 
	John W. Colby
	www.colbyconsulting.com 
		-----Original Message-----
		From: accessd-bounces at databaseadvisors.com
[mailto:accessd-bounces at databaseadvisors.com]On Behalf Of Charlotte
Foust
		Sent: Tuesday, July 01, 2003 11:01 AM
		To: Access Developers discussion and problem solving
		Subject: RE: [AccessD] Calling control (WAS How do I
determine which formcalled?)
		
		
		Have you tried raising a custom event from the unbound
form and sinking the event on the form that needs to retrieve the
information?
		 
		Charlotte Foust
			-----Original Message-----
			From: Roz Clarke
[mailto:roz.clarke at donnslaw.co.uk] 
			Sent: Tuesday, July 01, 2003 12:18 AM
			To: 'Access Developers discussion and problem
solving'
			Subject: [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/48155bf7/attachment-0001.html>