Query data connection not working in Infopath 2010 - InfoPath Dev
in

InfoPath Dev

Query data connection not working in Infopath 2010

Last post 03-27-2014 01:17 PM by Mel Clemente. 1 replies.
Page 1 of 1 (2 items)
Sort Posts: Previous Next
  • 03-26-2014 09:09 PM

    Query data connection not working in Infopath 2010

    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! 

     

    Filed under: , ,
  • 03-27-2014 01:17 PM In reply to

    Re: Query data connection not working in Infopath 2010

    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!

    Mel Clemente
    Qdabra® Software/ InfoPathDev.com
    The InfoPath Experts – Streamline data gathering to turn process into knowledge.™

Page 1 of 1 (2 items)
Copyright © 2003-2019 Qdabra Software. All rights reserved.
View our Terms of Use.