Subform References in Formulas

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I have a main form (FormA) with two embedded forms (subB and subsubC). On the
subsubC I have a textbox (tBox). I want to make a textbox on FormA the
control source of which will contain a formula using the value of tBox as a
parameter. How do I refer to the value in tBox when the formula will be on
FormA?
 
Don't think so.

Assuming that subsubC is a subform on subB which is a subform on FormA, that
should be:

Forms!FormA!subB.Form!subsubC.Form!tBox

That assumes that the name of the subform control on FormA is actually subB,
and that the name of the subform control on subB is actually subsubC. The
name of the subform control isn't always the same as the name of the form
contained within the control. If the subform was created by dragging one
form onto the other, the subform container will usually be named the same as
the form that was dragged. However, if the subform was created by adding a
subform control from the toolbox and then populating its properties (either
manually or using the wizard), the subform control will usually be named
something like Child1.
 
Back
Top