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

Charlotte Foust cfoust at infostatsystems.com
Tue Jul 1 10:00:38 CDT 2003


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/9460115c/attachment-0001.html>


More information about the AccessD mailing list