InfoPath Dev

So - the hyperlink is using a field for the URL? And you have a rule on the drop down to change it? And it isn't changing? Is this a browser form or a filler form?

I'd close InfoPath and check Task Manager to make sure all instances of the process are stopped. Then try re-installing again. If that doesn't work, would you email the copy of the form that is on your machine?

 Do any of your main data source fields have default values that depend on the data connection? I would check that first. You can download some of your existing files and open the XML with a text editor (like Notepad, or Notepad ++) to see the data. You can make changes to a test copy of your form, then preview the form with one of the XML ...

Thanks for updating!

You can look under Form Options > Promoted Properties in the designer. In the manifest, there are two places to look - xsf:listProperties has a fields node that will list the form fields, and assign them a GUID. Then xsf2:listPropertiesExtension has a fieldsExtension node that associates the form field GUIDs with the SharePoint column GUIDs - ...

 Instead of running the query when the form opens, add rules to the park field in your form. When a park is selected, set the query field for Park in your secondary data connection to the value of the main data source Park field. The run the query. That should return just the data for the selected park. For additional information on ...

 You should be able to use validation rules for this. You could have a condition like "Is this a single destination trip" = "Yes" and Depart From is blank, show the cannot be blank warning. I've attached a simple sample - save it locally and then right click and select design to open in design mode.

 Are you setting all of the fields? I haven't tried this - but I know if you set just the account id when trying to populate a people picker with rules, it doesn't resolve to the person... but it may also be that since this is happening via workflow, the people picker isn't resolving when the form reopens. Maybe add a helper field ...

 The list may be returning decimal values - which would explain the error. You may need to put the field on the form again, and set it to display the value as text so you can see what the actual value is.

 Oh good old SharePoint - it is displaying the date as date only, but it includes the time. Drag your secondary data source that has the date from SharePoint in it onto your form and be sure the date field is set to show the XML value, then preview. Then you'll be able to see the actual data and use a substring formula to get back just ...