Referencing a control on one form from another

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

Guest

I used this as a control source for a text box on form2

=Nz(Forms![Form1]![subform1].Form!txtAmount,0)
but I keep getting an error. What do I need to change?
 
That looks syntactically correct.

Is the subform container on Form1 named subform1? The subform container
isn't always named the same as the form being used as the subform. If there
aren't the same, make sure you're using the name of the container, not the
form.

(And, of course, Form1 needs to be open for this to work)
 
Back
Top