InfoPath Dev

I have an infopath form with 3 views. IT's for HR to search for candidates internally, no submissions, just read only. One view looks at the city and officer title of candidates, one by city and last year's rating, and the last one is city by the type of role they want. Each forms have buttons which open the other views. Each view has two cascading dropdowns to query on(City & Title, City & Rating, City & Role Desired).

 So here's the scenario. The individual opens the form on City & Title View. This is where it gets tricky. It can search via city & Title, the first view no problem. If I press one of the buttons that switches the view, it will carry over the city name, and whatever data was in the repeating table related to their city and title search. I also tried to just go to a different view without running a query, and while the query dropdowns work, it won't load any data.

Is this a rules thing? I'm hoping someone can "Stoupa"fy me with an answer!

So much depends on the data structure you have going on - want to put your template in a reply, under the options tab, and I can take a quick look?

(extra points for cute name pun)

Hillary,

Attached is my form, it opens in design view, perhaps you have some insight?  You are the best by the way!

Okay, I think I get what your issue is - if I query in the first view on City & Title, perhaps, and switch to City & Rating, the issue is that the data that has already loaded is still visible in the form.

Because, of course, your data has already been loaded in the initial query. :-)

You may want to add another rule to your Search By City & Rating button to clear the Officer Title query field. Let's say you've selected a title in that field, then you click your Search By City & Rating button - when you switch veiws, the OfficerTitle query field will still have the value set in it, and when you run the query for the City & Rating view, it will be affected by that value.

You could just hide the repeating section until "Load Candidates" has been clicked for the view - that is, if setting the button to use rules to run the main connection query works. I'm attaching your template with a few changes made - I think this will work, but don't use DB forms much, so I'm guessing a little. Save the template locally & right click, then select Design to open in design mode. I've modified your button that switches to City & Rating to clear your query fields. I've changed the C&R view Load Candidates button to toggle a helper field used to hide rows in the table and to run the Main Connection data query....

Thanks Hillary! Is there any way you could remove the form from your post? Kind of sensitive info, as I'm sure you can guess. (Especially with data connections)

Thanks for being such a "Stoupa"-endus resource!!!!!