[AccessD] Calling Subform Routine from Main Form

Thanks Lambert.  That works.  I just can't remember how to do it from time
to time.  Old age I guess...

Rocky
 




 	
	

-----Original Message-----
From: accessd-bounces at databaseadvisors.com
[mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Heenan, Lambert
Sent: Tuesday, July 31, 2007 11:12 AM
To: 'Access Developers discussion and problem solving'
Subject: Re: [AccessD] Calling Subform Routine from Main Form

Your it call from the main form with..

Me.SubformControlName.Form.RoutineName

If you want to call the routine from any place other than the subform or its
parent form then the routine needs to be made Public and you would call it
with...

Forms("MainFomrName").SubformControlName.Form.RoutineName

HTH

Lambert

-----Original Message-----
From: accessd-bounces at databaseadvisors.com
[mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Rocky Smolin at
Beach Access Software
Sent: Tuesday, July 31, 2007 1:08 PM
To: 'Access Developers discussion and problem solving'
Subject: [AccessD] Calling Subform Routine from Main Form



 
Dear List:
 
I can never remember this syntax:  I want to call a sub in a subform from
the main form's Current event.  Does anyone know this offhand?
 
MTIA
 
Rocky
 



 	
	

--
AccessD mailing list
AccessD at databaseadvisors.com
http://databaseadvisors.com/mailman/listinfo/accessd
Website: http://www.databaseadvisors.com
--
AccessD mailing list
AccessD at databaseadvisors.com
http://databaseadvisors.com/mailman/listinfo/accessd
Website: http://www.databaseadvisors.com

No virus found in this incoming message.
Checked by AVG Free Edition. 
Version: 7.5.476 / Virus Database: 269.11.0/927 - Release Date: 7/30/2007
5:02 PM