InfoPath Dev

 Is it possible to pass a sql parameter to the Main connection of an InfoPath form. When I open INFO path from access, I use  objIP.XDocuments.Open ("\\OurServer\test\test.xml")  Is there syntax to add to this line, like FieldName = "X"?

 I've search for days, no luck. Can't get the syntax to work. Any help would be appreciated!

What are you trying? Do you have code in the form to get the parameter values?

 Hi Hilary,

  I have a Main Connection set up which links to an Access db table. I'm trying to pass a command line parameter so that  when I open InfoPath form, the correct record displays. I do not have anything set up on the form itself yet.

You have to add code to the form to retrieve that parameter value. See this blog post for more info: https://blogs.msdn.microsoft.com/infopath/2007/02/26/passing-data-into-a-form-input-parameters/

 I added the code to the form, but I don't have the correct syntax on the access side when launching info path.

 Set objIP = CreateObject("InfoPath.Application")

This works:

 objIP.XDocuments.Open ("file://mytestserver/Poll_test.xml"

But Access doesn't accept, it highlights the line as incorrect syntax:  

    objIP.XDocuments.Open ("file://\\mytestserver\Poll_test.xml" / InputParameters "MyID=26") 

 (Excuse the typo)

Should have been:

 objIP.XDocuments.Open ("file:\\mytestserver\Poll_test.xml" / InputParameters "MyID=26") 

Have you tried the URL syntax instead? "file:\\mytestserver\Poll_test.xml?MyID=26" I don't know if that would work, but you may as well try it. :)

 The Url syntax didn't work.

 I got access to accept  objIP.XDocuments.Open ("\\MyTestServer\Mytest.xml /InputParameters 'Poll_ID=26'")

InfoPath opens, not the form, it doesnt seem to recognizing the /inputParameters , and I receive an error on the Access side. I'm guessing its a syntax error?

 

Picture of my error didn't post. But it said InfoPath cannot open the following file: ~ it copied the path through the poll_id=26  - and read that 'Then system could not find the path specified.

Not sure. I've never tried opening a form w/ input params from Access. You can attach your screenshot under the Option tab in a reply - perhaps someone else will have an idea.

 The syntax for URL and SharePoint, do not work for me from Access. I saw a command line option, a parameter was combined with. If I can get it to work, I'll post the syntax.