InfoPath Dev

This worked perfectly, in both IP 2003 and 2007..  I can't thank you enough! Bob

Thanks a lot, Hilary.  Maybe there's something you can see or think of, even if you don't have the older version.  I'm attaching a copy of the form here. There are actually 4 fields with this same issue, but the first one occurring in the main datasource is called "PrinBal" (myFields/MainTable/PrinBal).  Bob

Thanks a lot for the quick response.  We have actually been using current() in the default value, in a repeating table, and have been were able to pull values when a field (account number) matched in both primary and secondary data sources.  Now that I am creating my new form in IP 2007, the values are only pulling in for people ...

Hello, Hilary,  With the help of Microsoft Support, I was able to successfully use the current() function in the XPath code in a repeating table. A few years later, I am developing a new form using InfoPath 2007 and SP 2007, but am saving it in InfoPath 2003 format since my users still have InfoPath and SP 2003.  ...

Thanks a lot, Patrick.  I got some technical assistance from Microsoft, and they got me set up with both a Refresh button (which I had tried and done incorrectly before) and with an “Open and Save” rule which refreshes the data upon just opening the form.  They're both working very well.  They agreed that you have ...

I have read and successfully gone through the steps in the very informative article: How-to guide: Connecting an InfoPath form to an Access database.  Also, in looking through many posts here on the forum I have seen many questions and explanations about querying from and submitting data to Access DBs via InfoPath.  What I am doing ...

Hello, I am new to this forum, and found this issue which is almost the same as what I am experiencing. I am using a repeating table, and am setting a dollar value to a "balance" field, when an account number I have just entered matches an account number in an Access DB.  The difference in my results (from that of the ...