[AccessD] Call SubForm Event Procedure

Me.subformname.form.nameofprocedure


Example:

Me.WorkPlanDetailForm.Form.AddMeetingTime

Fires a procedure (AddMeetingTime) that runs a sql statement to insert records to database.

Barry G. Herring



---- Mark A Matte <markamatte at hotmail.com> wrote: 

=============
Thanks, normally I would...but I would still like to know how to call the 
event of a subform.

Thanks,

Mark A. Matte

>From: "Charlotte Foust" <cfoust at infostatsystems.com>
>Reply-To: Access Developers discussion and problem 
>solving<accessd at databaseadvisors.com>
>To: "Access Developers discussion and problem 
>solving"<accessd at databaseadvisors.com>
>Subject: Re: [AccessD] Call SubForm Event Procedure
>Date: Thu, 28 Dec 2006 14:20:35 -0800
>
>Why not put the operative code in a public routine on the subform and then 
>call it from both the OnCurrent event of the subform and from the main form 
>when you need it?
>
>Charlotte Foust
>
>-----Original Message-----
>From: accessd-bounces at databaseadvisors.com 
>[mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Mark A Matte
>Sent: Thursday, December 28, 2006 1:38 PM
>To: accessd at databaseadvisors.com
>Subject: [AccessD] Call SubForm Event Procedure
>
>Hello All,
>
>I have an OnCurrent event on a subform.  Can I call, or cause to fire from 
>the main form.
>
>Thanks,
>
>Mark A. Matte
>
>_________________________________________________________________
>Type your favorite song.  Get a customized station.  Try MSN Radio powered 
>by Pandora. http://radio.msn.com/?icid=T002MSN03A07001
>
>--
>AccessD mailing list
>AccessD at databaseadvisors.com
>http://databaseadvisors.com/mailman/listinfo/accessd
>Website: http://www.databaseadvisors.com

_________________________________________________________________
Dave vs. Carl: The Insignificant Championship Series.  Who will win? 
http://clk.atdmt.com/MSN/go/msnnkwsp0070000001msn/direct/01/?href=http://davevscarl.spaces.live.com/?icid=T001MSN38C07001