InfoPath Dev

You can get the path using XDocument.URI using VBScript. I've used it to pass the information to a field in the form. From that you can parse out the file name. Example: strPath = XDocument.URI dim oInfo set oInfo = XDocument.DOM.selectSingleNode("//my:FormPath") oInfo.text = strPath

You can get the path using XDocument.URI using VBScript. I've used it to pass the information to a field in the form. Example: strPath = XDocument.URI dim oInfo set oInfo = XDocument.DOM.selectSingleNode("//my:FormPath") oInfo.text = strPath

Thanks, we are going in the direction you have pointed us. We're going to give a try and hopefully get it to work.

Thanks for your response Matt. I looked over your HowTo and I see how it could work if you have a table that is in the main connection. However, what do you do if the table you're working on isn't a main data source? Example: Main Connection: Projects (ProjectID, ProjName); ProjectID is 1 to many to ProjectID in PContacts PContacts(PCID, ...

I've been looking around to see if there is a way to filter data from a secondary data source and am at a loss. This particular table is SQL. Once I drag the SDS table onto the form, the option to filter (as you would from a main data connection) isn't there. I want to be able to see all items for the section that fit a particular criteria in ...