InfoPath Dev

I have a form that has multiple views, each view is controlled by slightly different criteria.  The form was built based on a DB schema and is reading and writing to the DB.  There are also a couple of other data connections - a couple of lists that are read for the values on pull downs and a SharePoint Forms Library.  The fields that I need to drive the views were not anticipated at the time the form was created, I need to query the value of this field when the form is opened and while in the form based on rules behind buttons. 

Hi Marty,

Isn't this possible using InfoPath's built-in functionality? I'm thinking you can just add 'Open Rules' (that'll be in Tools > Form Options > Rules) that first queries your data connection/s and then switch to your desired view/s if the conditions are met. It might be tedious setting up and coming up with the right condiions if you are depending on a couple of values and views, but might be worth trying.

Hope it helps!

Thanks Mel, I've I got this working.