Charlotte Foust
cfoust at infostatsystems.com
Fri Mar 18 15:18:44 CST 2005
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