Re: Query data connection not working in Infopath 2010

Mel Clemente — Thu, 27 Mar 2014 20:17:45 GMT

Hi Cindy,

Field rules fire when the value of that field changes. I would suggest adding a helper field in your form and placing your query data connection rule in there. You'd then add a Form Load rule that sets that helper field's value to any value.

Hope it helps!

Query data connection not working in Infopath 2010

Cindy012 — Thu, 27 Mar 2014 04:09:55 GMT

Hi - I have created a data connection for my Sharepoint 2010 list to appear in my Form when I click on the drop down of my Application box. It is not set to automatically load each time the form opens. Instead, I wanted to create a rule to query data connection. So, I created the rule to 'each time the field changes', query data connection would run. But it does not. I see nothing when I click on the drop down button of my combo box. As a test, I created a rule to have a msgbox appear 'hello world' when the field changes and again it does not work. I know the rule isnt disabled but its almost like the drop down box is not activating the rule. I dont get any error messages either.

When I have the data connection to automatically load each time the form opens, then I see the values in my drop down list.

I would appreicate any insight how where to look or what might be the problem causer here.

Thanks.

---------

I have an update to this...

I played around with the rules and used the MsgBox rule and changed my dropdown box to combo box. I entered some dummy text in the combo box and the msgbox appeared with what I typed, so that works. But I dont want to have enter something into my combo box before my rule query data connection runs. Please help!

InfoPath 2010

Re: Query data connection not working in Infopath 2010

Query data connection not working in Infopath 2010