[AccessD] Calling a routine in a sub form

Charlotte:

Wonderful!  It was the Public in the subform module that I was missing.

Thanks and regards,

Rocky Smolin
Beach Access Software
http://www.e-z-mrp.com
858-259-4334

----- Original Message ----- 
From: "Charlotte Foust" <cfoust at infostatsystems.com>
To: "Access Developers discussion and problem solving" 
<accessd at databaseadvisors.com>
Sent: Friday, March 18, 2005 1:18 PM
Subject: RE: [AccessD] Calling a routine in a sub form


> Rocky, the routine being called has to be a public method of the
> subform.  Then you can call it like this:
>
> Call Me.SubformControl.Form.MyMethod()
>
> Charlotte Foust
>
>
> -----Original Message-----
> From: Rocky Smolin - Beach Access Software [mailto:bchacc at san.rr.com]
> Sent: Friday, March 18, 2005 12:15 PM
> To: AccessD at databaseadvisors.com
> Subject: [AccessD] Calling a routine in a sub form
>
>
> Dear List:
>
> I can never remember how this syntax goes.  I want to call a routine in
> a subform from a main form.  It's actually in the after update event of
> a combo box.  I want to set the focus to the first occurrence of the
> selected record in the sub-form to whatever the user selects in the
> combo box on the main form.  So the routine in the subform does the
> RecodsetClone.FindFirst/Bookmark thing.
>
> Any help appreciated.
>
> MTIA
>
> Rocky Smolin
> Beach Access Software
> http://www.e-z-mrp.com
> 858-259-4334
> -- 
> 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
>