John W. Colby
jwcolby at colbyconsulting.com
Mon Dec 13 10:52:00 CST 2004
Jeff, It turns out that the form's control collection contains a pointer to the subform so you don't need the tab in there. John W. Colby www.ColbyConsulting.com Contribute your unused CPU cycles to a good cause: http://folding.stanford.edu/ -----Original Message----- From: accessd-bounces at databaseadvisors.com [mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Mitsules, Mark Sent: Monday, December 13, 2004 10:15 AM To: 'Access Developers discussion and problem solving' Subject: RE: [AccessD] Referencing a subform on a tab control Wild Wild Wild guess...best of luck;) [Forms]![frmMainForm]![sfrm1stSubForm]![ssfrm2ndSubForm].Requery Mark -----Original Message----- From: Jeff Barrows [mailto:Jeff at outbaktech.com] Sent: Monday, December 13, 2004 9:45 AM To: AccessD Subject: [AccessD] Referencing a subform on a tab control Morning all!! I have a situation where I need to refresh or requery the data on a subform located on in a tab control. I am adding a new record using a popup form and when I close the popup, I need to display the data in the subform with the new record. I know that I have done this (or something like this) before, but it is Monday morning and my brain is not fully engaged yet. TIA Jeff B -- 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