InfoPath Dev

Just wanted to come back and say thanks. With roles and some creative conditions, the form now works.

I actually understand that!! My only issue is that when I put the three users into the role, if one of them leaves the company, it becomes a manual change to the form to add their replacement. Getting our AD group to set up a special group is not easily doable. Thanks for your help. Now I have a ton of coding to do.  

Yes the form is sent as an attachment to the email using IP 2003. This is what I want (And it is to open in View 2 for User 2, and View 3 for User 3) but not sure how to do or what I am doing wrong. I did not set anything in the data connection.  Is there something I shoud be setting to get what I want?   

I agree what you did does work but what I am trying to do is this: On Submit - change view to view 2 and then submit to user 2 Then set a new rule on the same submit button to change to view 3 and submit to user 3 Then a thiurd rule to close the form. Sequential rules on the submit button I am not using the form rules off the tool bar.  

Maybe a simpler question If you switch a to a new view before submitting via email, why doesnt the new view remain?  

I am using IP 2003 and emailing results (xsn files). On a new form I have, upon submit I set a field "IsSubmitted" to Yes and then in the Tools > Forms Options> Open and Save Rules, I have it set to swtitch views based on this field. But now I need to send a courtesy copy of the form to a third party and I need to ...

I do not understand   Do you have a query that is not seen by the end user running on submit?    

I am using IP 2003 tied to a database I have a new form that collects 2 data elements and upon submit, the 2 fields go to the database.  That works well. Because the form will get used throughout the day, rather than close the from, I just set the 2 values to blank after the database submission and leave the form open. However, ...

It was easier than that.  And a dumb mistake I had the field in the main connection only set at 100 in SQL but in the drop down secondary connection it was 500  Changing Main to 500 fixed my problem  

How would I set a default?  Even if I wanted to do that? I deleted the data connection and recreated it and updated the ODC connection  Still same issue, even if binding on a different field I also tried creating a brand new form and added a drop down to the same database and same condition. I am lost. Here is the text form the ...