InfoPath Dev

I have a drop down populated from external data source in a browser enabled form and I have checked the option "Automatically retrieve data when form is opened". However,  I have to click once before the drop down is populated. When I was developing the form I found out that this started happening when I placed People selector ...

Thanks for your solution. I got it working now. In my case I needed "If Any Occurrences of drop down are equal to Current User then switch the view".

Here is how my data structure looks like:-myFields   -queryFileds       -tns:GetUserCollectionFromGroup            -Users                -User (this is a repeating group)                       ...

Yes. But I also tried to query directly the data source.  The rule is set under Tools-> Form Options -> Open and Save -> Rules. And here is the codition for the ...

I'm doing a check to see if the current user is in the drop-down (from secondary data source)  and switch to a different view if he is. So, instead of doing conditional formatting I'm adding a rule in the form options. I followed the steps that you provided but it didn't work for me. Any help would be apprecatied

 Thanks for your reply. Just to make sure that we are using same terminology when yo say 'first drop down'. The value in the second (cascading) drop down is changed when you switch the value in the first. Right? What exactly do you do in your rule? Based on your solution I did added a Rule then added an  Action "Query ...

 I'm doing something similar except that instead of using a filter I change FileLocation to switch to a different view  based on the selection. The reason I can't use filter is because I have multiple values in my lookup column. Cascading drop-down is working fine except that after the form is submitted only the selected value ...