[AccessD] Referencing a subform on a tab control

Jeff - Only because I got up early!


	Public sub RequerySubForm()

        	Me.[subFormControlName].Form.Requery

	End sub


You can put this procedure into your main form and call it when your popup
form closes.

The phrase [subFormControlName] represents the name of the subform/subreport
control, not the name of the subform itself.  After you type 'Me.'
intellisense will give you the name of the subform/subreport control.

HTH
Dan Waters
ProMation Systems


-----Original Message-----
From: accessd-bounces at databaseadvisors.com
[mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Jeff Barrows
Sent: Monday, December 13, 2004 8: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