JWColby
jwcolby at colbyconsulting.com
Wed Jan 24 14:33:10 CST 2007
IOW, there is code run in the OnExit of the text box that you want to make sure runs in the OnExit of the subform? The OnExit of the subform runs in the parent form because the subform is a control on the parent form, and the OnExit is a property of the subform control. You could pull the code out of the OnExit of the control and make it a PUBLIC function in the subform. Then in the OnExit of the subform up in the parent form, call the function back down in the subform. Or did I miss the train altogether? John W. Colby Colby Consulting www.ColbyConsulting.com -----Original Message----- From: accessd-bounces at databaseadvisors.com [mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Mark A Matte Sent: Wednesday, January 24, 2007 2:24 PM To: accessd at databaseadvisors.com Subject: [AccessD] Leaving Subform Hello All, In A97 I have a textbox on a subform...there is an OnExit event on the textbox...this fires when I move to another field onthe subform...but can I cause it to fire when you leave the subform? Thanks, Mark A. Matte _________________________________________________________________ FREE online classifieds from Windows Live Expo buy and sell with people you know http://clk.atdmt.com/MSN/go/msnnkwex0010000001msn/direct/01/?href=http://exp o.live.com?s_cid=Hotmail_tagline_12/06