Heenan, Lambert
Lambert.Heenan at AIG.com
Tue Jul 31 13:11:49 CDT 2007
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