J JimP May 23, 2007 #1 A "ParentForm" has 2 sub-forms - "SubFormA" and "SubFormB". How do I call a procedure on "SubFormB" from "SubFormA"?
A "ParentForm" has 2 sub-forms - "SubFormA" and "SubFormB". How do I call a procedure on "SubFormB" from "SubFormA"?
S Scott McDaniel May 23, 2007 #2 A "ParentForm" has 2 sub-forms - "SubFormA" and "SubFormB". How do I call a procedure on "SubFormB" from "SubFormA"? Click to expand... Generally, if you find that you must use a sub or function from several different places you'd be better off moving it to a Standard Module and calling it from there. However: Me.Parent.NameOfSubformBCONTROL.Form.NameOfYourProcedure Make sure that you use the name of the Subform Control, it's not necessarily the name of the form being used as a subform. Scott McDaniel scott@takemeout_infotrakker.com www.infotrakker.com
A "ParentForm" has 2 sub-forms - "SubFormA" and "SubFormB". How do I call a procedure on "SubFormB" from "SubFormA"? Click to expand... Generally, if you find that you must use a sub or function from several different places you'd be better off moving it to a Standard Module and calling it from there. However: Me.Parent.NameOfSubformBCONTROL.Form.NameOfYourProcedure Make sure that you use the name of the Subform Control, it's not necessarily the name of the form being used as a subform. Scott McDaniel scott@takemeout_infotrakker.com www.infotrakker.com