InfoPath Dev

Hi Daniel-  Are experimenting with the "var" lines of code, I got it to work!!!!!!!!!!!!!!!! The correct path names are:

var form1Field = XDocument.DOM.selectSingleNode("/dfs:myFields/my:SetUserName");

var form2Field = objNewForm.DOM.selectSingleNode("/dfs:myFields/my:SetName");

I needed to use "dfs" and drop the "/dataFields/"  in the path name.

Thank you very much again for your help Daniel!!

RhysAZ 

See article Programattically Transfer Data Between InfoPath Forms for details and instructions on how to transfer data between two InfoPath forms programmatically using a JScript example similar to the above.

If using SharePoint you can submit the data to a SharePoint list from the first form eith using a CAML query and the SharePoint lists web service or the forms main submit data source, then load the data into the second form from the SharePoint list using a secondary data connection.  If not using SharePoint, this can also be achieved by submitted to an external database (Access) or even an xml file (default) which can then be used as a secondary datasource in the second form to retrieve the data. 

• See InfoPath - Update Existing SharePoint List Item Programmatically Using CAML for details and instructions on how to Submit data to a SharePoint using a CAML Query and the SharePoint Lists web service.
• See Using Secondary InfoPath Data Connections to retrieve data from a SharePoint List or Library for details and instructions on how to configure and use secondary data connections from an infoAPath from to retrieve data from a SharePoint list.
• See Submit InfoPath form to SharePoint List or Library using Content Type for instructions on how to configure an InfoPath form's main submit data connection to submit to a SharePoint library by publishing the form template as a site content type and associating the content type with the form library being submitted to.

Thank you again Daniel. Great info!

I have been following your example and trying to rewrite the same code in C#

here is my code

1. string strNewFormPath = @http://pathToForm;

2. MSXML2.IXMLDOMDocument3 objNewForm = new MSXML2.DOMDocument50Class();

 What's the exact error that you're getting?

Following error is displayed when I run source form, or the form from which I want to send/copy fields into the second form 

Object reference not set to an instance of an object.
   at _c_Intelligence_Analysis.FormCode.CTRL120_5_Clicked(Object sender, ClickedEventArgs e)
   at Microsoft.Office.InfoPath.Internal.ButtonEventHost.OnButtonClick(DocActionEvent pEvent)
   at Microsoft.Office.Interop.InfoPath.SemiTrust._ButtonEventSink_SinkHelper.OnClick(DocActionEvent pEvent)

when I run debug and look into watch of all objects, and get to number 9 from the above code

9. objNewForm.selectSingleNode("/my:myFields/my:group3/my:group4/my:txtMonthlySummary").text = objExternalData.selectSingleNode("/my:myFields/my:group3/my:group4/my:txtMonthlySummary").text;

it says that for this object

objExternalData.selectSingleNode("/my:myFields/my:group3/my:group4/my:txtMonthlySummary").text;

it states

Reference to undeclared namespace prefix: 'my'

 Thank you for your time

 That certainly is puzzling.  Would you mind putting up an example of one of these XML files on here so someone could look at it?

<my:group3>

<my:txtCreatedBy>me</my:txtCreatedBy>

<my:attachmentBox xsi:nil="true"></my:attachmentBox>

<my:txtComment></my:txtComment>

<my:field2 xsi:nil="true"></my:field2>

<my:txtMonthlySummary></my:txtMonthlySummary>

<my:ddlUpdateType>Update Report</my:ddlUpdateType>

<my:dtDate></my:dtDate>

<my:txtHyperLink>http://</my:txtHyperLink>

</my:group3>

<my:signatures1></my:signatures1>

</my:myFields>

Hello Daniels,

 I am experiencing the same issues defining dfs because of ambiguous xpath.  I am also using Access 2003 as my main data source and when I look at the data field Details all I see is "Key_Field (Optional attribute field)" which is the unique indentifier field I am trying to pass from form 1 to form 2 when it's opened.  There is no Namespace defined for this field that I can see.   The only time I see a Namespace being defined is within myFields, not either queryFields or dataFields I am pulling from Access 2003.

I believe this is also addressed within this article when you suggest using a var to define this...the problem is you don't seem to mention where exactly in the code this should be defined.

Can anyone advise on how I should implement this within the code example you've provided?

var  form1Field = XDocument.DOM.selectSingleNode("/my:myFields/my:dataFields/my:SetUserName");

var  form2Field = objNewForm.DOM.selectSingleNode("/my:myFields/my:dataFields/my:SetName");

Then set the value of the form2 field using the following:

form2Field.text = form1Field.text;