Re: InfoPath 2003 / VBScript Reference bound (form) field names

Wheels — Fri, 24 Apr 2009 14:34:24 GMT

Thank you Hillary.

WHEELS

Re: InfoPath 2003 / VBScript Reference bound (form) field names

Hilary Stoupa — Mon, 20 Apr 2009 00:46:33 GMT

If you save your form as source files, you can look at template.xml or sampledata.xml to see your main data source XML, this may help you get the XPath to your data nodes correct. I'd guess that it is going to be "dfs:myFields/dfs:dataFields/d:tbl_GC100/@Lockbox".

InfoPath 2003 / VBScript Reference bound (form) field names

Wheels — Wed, 15 Apr 2009 13:45:17 GMT

Good morning.

I struck out with JScript so now I am using VBScript.

I have the following functions:

Public Function StoreFields()

Dim Lockbox, Cash_Deposit_Date, Batch_Number

Lockbox=XDocument.DOM.selectSingleNode("dfs:myFields/my:Lockbox");

Cash_Deposit_Date=XDocument.DOM.selectSingleNode("dfs:myFields/my:Cash_Deposit_Date");

Batch_Number=XDocument.DOM.selectSingleNode("dfs:myFields/my:Batch_Number");

End Function

Public Function PopulateFields()

XDocument.DOM.selectSingleNode("dfs:myFields/my:Lockbox")= Lockbox;

XDocument.DOM.selectSingleNode("dfs:myFields/my:Cash_Deposit_Date") = Cash_Deposit_Date;

XDocument.DOM.selectSingleNode("dfs:myFields/my:Batch_Number") = Batch_Number;

End Function

The reference to the form fields appear to be incorrect. Under my Data Source (main connection) I have: myFields --> dataFields --> d:tbl_GC100 --> :Lockbox, :Cash_Deposit_Date, and :Batch_Number.

How do I reference these fileds correctly? There are several fields bound to the form that I can reference correctly.

Thank you, WHEELS

Newbie Questions

Re: InfoPath 2003 / VBScript Reference bound (form) field names

Re: InfoPath 2003 / VBScript Reference bound (form) field names

InfoPath 2003 / VBScript Reference bound (form) field names