 |
 | Home | Contact Us | FAQ | Search & Site Map | Link to Us |
 | Sign In | Join | Other 45 Sites in Network |
MS Access Forum / Forms / July 2007Display value in a control on another form
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 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  SignatureArvin Meyer, MCP, MVP http://www.datastrat.com http://www.mvps.org/access http://www.accessmvp.com >I have a Main form with an underlying table called Inquiries. This includes >a [quoted text clipped - 9 lines] > Many thanks > CW 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 [quoted text clipped - 15 lines] > > Many thanks > > CW |
Reply to this Message |
 Sign In
 Join
 My Latest Posts My Monitored Threads My Blog My Photo Gallery My Profile My Homepage Start New Thread Enable EMail Alerts Rate this Thread
|
©2009 Advenet LLC Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.