https://www.infopathdev.com:443/forums/131.aspxqRules adds support to your InfoPath forms. With qRules, you can add features to your form that require code, but without having to write it. enCommunityServer 2007 SP3 (Build: 31118.962)https://www.infopathdev.com:443/forums/thread/96000.aspxTue, 18 Feb 2014 21:33:13 GMT033a2e2d-04e2-4a9d-be01-a4634161eefd:96000rob_519710https://www.infopathdev.com:443/forums/thread/96000.aspxhttps://www.infopathdev.com:443/forums/commentrss.aspx?SectionID=131&PostID=96000<p>&nbsp;Doh!!!</p>https://www.infopathdev.com:443/forums/thread/95997.aspxTue, 18 Feb 2014 21:14:24 GMT033a2e2d-04e2-4a9d-be01-a4634161eefd:95997Hilary Stoupa0https://www.infopathdev.com:443/forums/thread/95997.aspxhttps://www.infopathdev.com:443/forums/commentrss.aspx?SectionID=131&PostID=95997<p>Do you have postback set to always on the control bound to the Facility field?</p>https://www.infopathdev.com:443/forums/thread/95996.aspxTue, 18 Feb 2014 21:06:43 GMT033a2e2d-04e2-4a9d-be01-a4634161eefd:95996rob_519710https://www.infopathdev.com:443/forums/thread/95996.aspxhttps://www.infopathdev.com:443/forums/commentrss.aspx?SectionID=131&PostID=95996<p>&nbsp;My form is an admin approved form,&nbsp; when I test the form with InfoPath preview the ModifySQLQuery runs fine.&nbsp; When I publish the form and try to test in the browser the ModifySQLQuery command does not appear to be running.&nbsp; The command is set to run via rules on when a field is changed. I am not getting an error message.&nbsp; </p><p>&nbsp;The command is: concat(&quot;ModifySqlQuery /dsname=GetRoutes /where=where Facility=&#39;&quot;, ., &quot;&#39;&nbsp;&nbsp; Order by Facility,InternalRunNbr&quot;).&nbsp; and is set to run when Facility changes.</p><p>Any ideas or suggestion as to why this would be occurring?</p><p>&nbsp;</p><p>Any assistance is appreciated.</p><p>Thank you</p>