Dynamic Data Connections

[Paul]

I have used an article titled "Submitting to 'this' document library" in the
MSDN InfoPath block to make an InfoPath form dynamic with reference to the
Submit data connection.

Now I need to find a way to do the same with secondary data connections. I
have a form that pulls information from an InfoPath form that has already
been published to a SharePoint document library. I would like to be able to
update the location of this form dynamically so I do not have to change the
form when I have to create a new sub-site that uses that form.

I have tried changing the FileLocation value for the FileQueryConnection in
the Form_Loading event. The value changes but the data is still coming from
the old location. My guess is that the connection has already been
established. So I either need to make the change somewhere else or find a way
of refreshing the connection so it uses the new FileLocation value.

Any suggestions?

Thanks