InfoPath Dev

 Perfect, glad you have it working! :)

 Sorry - I'm still having trouble understanding. Can you attach your form under the options tab?

 So - that is not the correct syntax for the delete command, first off - you may want to refer to the user guide. You want to delete the whole row of BPSubmit for a certain condition, right?

 Hi - I'm sorry, I tried to read all this and just got overwhelmed. I take it from your screenshots that you are using InfoPath 2007 and SharePoint 2007 and your form is a browser form (which is why you are having issues filtering your dropdowns). Is this correct? So - you are probably going to have to use an owssvr.dll data connection ...

 You'll have to go into Central Admin and find out where they are. http://technet.microsoft.com/en-us/library/ee748619(v=office.14).aspx

 Some of your screenshots are not showing up - but the short answer is "yes". The Delete command's xpath parameter can have a filter in it indicating which row to delete. You can use a concat statement for the command - like: concat("Delete /xpath=my:myFields/my:group1/my:group2[my:field2 = '", fieldSomethingElse, ...

 So - the admin updates the form and re-submits it. Then the non admin opens the form and does ... what? Can they still change it? If it is read only at this point for them, why would they submit it? Sorry, just a li'l confused. :)

 Have you checked your SharePoint trace logs for the correlation ID? You'll find more information on what has gone wrong there, I imagine...

 Do be very careful with default values - sometimes they are exactly what you want, sometimes not. For example, if you had an Invoice form with a secondary data connection that had items and their prices - if you use default values for price and the price changes - what happens when you re-open an old invoice? Most likely, the price gets ...

 Do any of your fields in your form have default values that depend on info from your secondary data sources? Once the year changes, do they ever require editing? If not, I'd just copy data to an archive site, but I'd probably also add something to the template to not allow submit if it the form that is opened isn't the ...