InfoPath 2003 / VBScript / Access (Function variable not Public?) - InfoPath Dev
in

InfoPath Dev

InfoPath 2003 / VBScript / Access (Function variable not Public?)

Last post 04-15-2009 12:05 PM by Wheels. 0 replies.
Page 1 of 1 (1 items)
Sort Posts: Previous Next
  • 04-15-2009 12:05 PM

    InfoPath 2003 / VBScript / Access (Function variable not Public?)

    Good afternoon.

    I have the following code:

    Public Function StoreFields()

    Dim Lockbox, Cash_Deposit_Date, Batch_Number

    Lockbox = XDocument.DOM.selectSingleNode("dfs:myFields/dfs:dataFields/d:tbl_GC100/@Lockbox").Text

    Cash_Deposit_Date = XDocument.DOM.selectSingleNode("dfs:myFields/dfs:dataFields/d:tbl_GC100/@Cash_Deposit_Date").Text

    Batch_Number = XDocument.DOM.selectSingleNode("dfs:myFields/dfs:dataFields/d:tbl_GC100/@Batch_Number").Text

    End Function

    Public Function PopulateFields()

    XDocument.DOM.selectSingleNode("dfs:myFields/dfs:dataFields/d:tbl_GC100/@Lockbox").Text = Lockbox

    XDocument.DOM.selectSingleNode("dfs:myFields/dfs:dataFields/d:tbl_GC100/@Cash_Deposit_Date").Text = Cash_Deposit_Date

    XDocument.DOM.selectSingleNode("dfs:myFields/dfs:dataFields/d:tbl_GC100/@Batch_Number").Text = Batch_Number

    End Function

    Sub CTRL1_8_OnClick(eventObj) ' New Record button

    End Sub

    Sub CTRL10_7_OnClick(eventObj)

    ' Submit Button

    StoreFields

    XDocument.UI.Alert(Lockbox) 'Empty / Null Field

    End Sub

    I have tested the variables in the Functions and the are correct. What am I doing wrong here? 

    Thank you, WHEELS

Page 1 of 1 (1 items)
Copyright © 2003-2019 Qdabra Software. All rights reserved.
View our Terms of Use.