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....