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/65064.aspxThu, 10 Mar 2011 17:07:09 GMT033a2e2d-04e2-4a9d-be01-a4634161eefd:65064wbeard520https://www.infopathdev.com:443/forums/thread/65064.aspxhttps://www.infopathdev.com:443/forums/commentrss.aspx?SectionID=41&PostID=65064<p>I&#39;ve solved my dilemma... mostly.&nbsp; The only issue is that now all of the tests and their data is loaded into every form slowing down how quickly the form loads and returns data.</p> <p>On the very top of my form I created the interface for the user to be able to select the test they want to take.&nbsp; Below that I have the interface for the test itself.&nbsp; Once the user selects the test via a command prompt, the @TestType node for the users test is populated.&nbsp; This sets off a chain of events.&nbsp; </p> <ol> <li> <div>The selected test interface is hidden through a conditional format stating if @TestType is not blank then hide itself</div></li> <li> <div>The repeating section defining the test questions and possible answers are populated via visual basic code (ran under the change event of the @TestType node) and filters on the controls</div></li> <li> <div>The test interface is shown through a conditional format stating if @TestType is blank then hide itself.&nbsp; Since it is no longer blank, the test interface is shown.</div></li></ol> <p>When the user has finished taking the test and has submitted it.&nbsp; The form is reopened and the user is again presented with the interface to select the test.&nbsp; The difference this time, is the previously taken test has turned colors and the command button disabled indicating the test was previously taken.</p>https://www.infopathdev.com:443/forums/thread/64942.aspxMon, 07 Mar 2011 22:23:33 GMT033a2e2d-04e2-4a9d-be01-a4634161eefd:64942wbeard520https://www.infopathdev.com:443/forums/thread/64942.aspxhttps://www.infopathdev.com:443/forums/commentrss.aspx?SectionID=41&PostID=64942<p>I have a form that will load test questions from multiple tests.&nbsp; I would like the user to select a test and only those test questions populate the rest of the form.&nbsp; What is the best way of achieving this?&nbsp; </p> <ul> <li> <div>Is it possible to change the SQL query at load time to only retrieve that one specific test?</div></li> <li> <div>Is it possible to have an initial view where the user selects the test to take and then the other view shows up?</div></li> <li> <div>Is it possible to create a form where the user can select the test and then pass that test ID to the InfoPath form?</div></li></ul> <p>I am doing this all within InfoPath and the provided VB.net libraries.&nbsp; I am working on providing an interface where the user can see the different tests they are requried to take and be able to select one to take.&nbsp; I have the InfoPath form set up in such a way that when I pass the Test ID to the InfoPath XPath, the rest of the form configures itself appropriately using filters.</p> <p>&nbsp;Thanks for your willingness to help</p>