Display value in a control on another form

[Guest]

I have a Main form with an underlying table called Inquiries. This includes a
field called InsuranceValue.
I have several tabbed pages hanging off Main, with subforms handling various
details of each transaction.
One of these is Quotes. I would like to display the InsuranceValue on this
page.
I created a textbox on it and have tried a whole bunch of things in the
Control Source to pull through the value and all I ever get is #Name?
Please, somebody, how should I be doing this!!!
Many thanks
CW

 

[Arvin Meyer [MVP]]

The best way is to display InsuranceValue above the tabs so that it can be
seen no matter which tab one is on. If that is not possible and the subforms
are linked to the main form, the syntax is:

= Forms!MainFormName!InsuranceValueFieldTextboxName

 

[Guest]

At last! Wonderful! Thanks so much!
CW

The best way is to display InsuranceValue above the tabs so that it can be
seen no matter which tab one is on. If that is not possible and the subforms
are linked to the main form, the syntax is:

= Forms!MainFormName!InsuranceValueFieldTextboxName

--
Arvin Meyer, MCP, MVP
http://www.datastrat.com
http://www.mvps.org/access
http://www.accessmvp.com