https://www.infopathdev.com:443/forums/41.aspxIf you're not sure where to ask your question, ask it here. If necessary, our moderators will make sure it gets classified in the correct board.enCommunityServer 2007 SP3 (Build: 31118.962)https://www.infopathdev.com:443/forums/thread/122608.aspxMon, 23 Mar 2020 16:45:26 GMT033a2e2d-04e2-4a9d-be01-a4634161eefd:122608welshartnow0https://www.infopathdev.com:443/forums/thread/122608.aspxhttps://www.infopathdev.com:443/forums/commentrss.aspx?SectionID=41&PostID=122608What a wonderful knowledge you have of this product, thank you so much for sharing this tip, it sounds perfect. Kind regards Martinhttps://www.infopathdev.com:443/forums/thread/122605.aspxMon, 23 Mar 2020 14:53:48 GMT033a2e2d-04e2-4a9d-be01-a4634161eefd:122605Hilary Stoupa0https://www.infopathdev.com:443/forums/thread/122605.aspxhttps://www.infopathdev.com:443/forums/commentrss.aspx?SectionID=41&PostID=122605So, here's what I do, usually. Set the data connection to not run when the form loads (that will be an option in the data connection wizard, I think on the last screen - it is a checkbox). Then, in the form load rules, add a rule to set the archive query field to false, then add another rule to run the query.https://www.infopathdev.com:443/forums/thread/122603.aspxSun, 22 Mar 2020 19:32:09 GMT033a2e2d-04e2-4a9d-be01-a4634161eefd:122603welshartnow0https://www.infopathdev.com:443/forums/thread/122603.aspxhttps://www.infopathdev.com:443/forums/commentrss.aspx?SectionID=41&PostID=122603I have created a data connection to my list and wish to retrieve list items where "archive = no". This is not dependent on any user choice but needs to load within the form as a drop down. The user should not have to do anything non archived items will automatically display. I know I need to set archive = no & query the data connection on this basis but where do I do this, I can't place it on a particular field since it does not happen as a consequence of what happens in the form, it's an up front choice made by me? So that the correct items display within the drop down. Not sure where I place this rule - should it be on form load? Or elsewhere? Thanks for any advice here.