Referencing a control on one form from another

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?
 
D

Douglas J Steele

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)
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Main Form/Subform/Command Button to Open Another Form 3
How to always get the top level form reference, when calling from any subform/subform... 0
refer a control form a sub form 6
Referring to a control on another form 5
Need help on how to pass calculated field from a form to another form 0
copying from a textbox 1
Referencing a control on a subform 2
Form with two subforms 1

Top