Passing Input Parameters to InfoPath 2007 Form via URL

[InfoPathJack]

I have read a lot of older blogs/newsgroup discussions around this, but no
real answers. I am hoping that things have changed and someone has an Idea
on how to do this. Seems simple enough. I want to pass in a Tag number to
be used to retrieve data from a SQL database on from open. The form is
published to a Sharepoint document library.

Thanks for any help you can give me.

J

 

[S.Y.M. Wong-A-Ton]

Check out this blog post:
http://blogs.msdn.com/infopath/archive/2007/02/26/passing-data-into-a-form-input-parameters.aspx

 

[InfoPathJack]

I have been working on this issue myself for sometime now. I read the blog
that S.Y.M. Wong-A-Ton suggested and it got me pretty far, except that the
parameters would not pass to my form once I published it to the library or to
a network location.

What I found was that Sharepoint likes to contsruct its own url structure
when it makes the call. It then attaches your parameter(s) at the end of the
string and they do not pass thru.

What I did to get around this was use the fully constructed URL that
sharepoint creates and then embedded my parameter before all of the other
options.

Here is an example:

http://Server/sites/projectsite/_la...lates/TestLoad_3.xsn?Tag=M123&OpenIn=Browser#

By doing the above I was able to successfully pass the parameter to
InfoPath. Keep in mind that you have to put the code in the On Load Event
handler as suggested in the other blog.