<div>
Typically in these scenarios I ask, &quot;Are you sure you need 2 forms?&quot;, most of the time people think they need to pass data between forms, but inreality just need to use one form with one dataset serve multiple functions via data views.<br />
<br />
90% of the time people do not understand views, and how you can have the same data work for multiple uses and views.<br />
<br />
Typically if you do need to pass data from one form to the next you can either launch the 2nd form and pass variables when it is opened. Or with the object model reference one from the other.<br />
<br />
If you are using a database, another trick i have used is to save a record with a flag bit. Open the second form and query the table and grab the record which is flagged and then reset the flag.<br />
<br />
But first I would really explore why you need two forms which reference the same data. &nbsp;If you architect it right, you typically do not and you can save yourself a ton of complication..<br />
<br />

</div>


<div>
Ok good enough.<br />
<br />
Seems a bit late to be figuring this part out. &nbsp;I searched a bit to find a page I used a long time ago and could not find it but you can pass variable to a new launched form via code. I think in MSDN they should have it documented too.<br />
<br />
Does the buyer just get notification or do they have to enter data and send it back? Do they have Infopath? &nbsp;If they can access a central template why not have the query happen when they open it? &nbsp; &nbsp;With IP 2007 you could just send them a view instead of the form, but it looks like you are using 2003 and I digress...<br />
<br />
Another option, which may be simpler is for your buyer form, is to overwrite any sensitive data before it emails the copy to them. &nbsp;If you have a link to the manager data and the CRM data then when it got back to the manager it could requery, I assume you are doing data updates since their is a backend database that could get updated anyway.<br />
Are you using a method for IDing the user such as an AD webservice or code? So that you know when a manager opens it versus a buyer? &nbsp;Then you can route to views specific to each person. <br />
<br />
But those are my thoughts. &nbsp;<br />
Good Luck.<br />
&nbsp;
</div>


<div>
<div class="content wysiwyg-content">
Hello Experts,<br />
I have two forms and I would like to pass a value in a text field from one form to another using a button. &nbsp;Currently I have a button that opens the other form...and as mentioned I would like it to also pass a value from the already opened form. &nbsp;BTW, my backend is Access 2003 and I am not using a Web Service or SharePoint...so I need to do this with code and since I already have existing VB code I need to stick with that...thanks.<br />
<br />
p.s. This is the XPath for the text field value I wish to pass to the other form when it's opened by the button: &nbsp;../../@Key_Field<br />

<pre><code class="code-1 nolinks" id="code-261823"><span>Sub SendToBuyer_OnClick(eventObj)</span>
<span>Dim wshShell </span>
<span>    Set wshShell = CreateObject(&quot;Wscript.Shell&quot;)</span>
<span>    wshShell.Run (&quot;P:\Purchasing\IAC-TX40\Databases\Frontlog\Production\FrontlogToolProdEMail.xsn&quot;)</span>
<span>End Sub</span>
</code></pre>
</div>
</div>


Hello Experts,
I have two forms and I would like to pass a value in a text field from one form to another using a button.  Currently I have a button that opens the other form...and as mentioned I would like it to also pass a value from the already opened form.  BTW, my backend is Access 2003 and I am not using a Web Service or SharePoint...so I need to do this with code and since I already have existing VB code I need to stick with that...thanks.

p.s. This is the XPath for the text field value I wish to pass to the other form when it's opened by the button:  ../../@Key_Field

Passing Parameter from One Form To Another Using VB

Microsoft InfoPath is a software application for designing, distributing, filling and submitting electronic forms containing structured data. The product features a WYSIWYG form designer in which the various controls (e.g. textbox, radio button, checkbox) are bound to data, represented separately as a hierarchical tree view of folders and data fields. All the data stored in InfoPath forms are stored in an XML format. Secondary data sources can be built into the form or they can be accessed through an external data connection to SharePoint or a Web service.