InfoPath Dev

Is it at all possible to create a "dynamic" submit button.  I would like to submit the form to a specific library based off a field in the form.  For example... In SharePoint we have a separate libraries for each client's documents. From a list of form templates the user opens a general use form that details the ...

see it was something stupid I missed.  Thank you!  It's nice to know that the light at the end of the tunnle is you and not an on coming train!  :)

Hilary, yes the query is pulling in the FirstName. See the screen cap attached.

actualy that is what I am intending.  I need a field that shows who opened the form, then I have rules based on that information.  And thank you for your guidence.

I am trying to pull in the name of current user I would normaly use ADWS to do this but the client dosn't have it.  So I'm using the following blog but to no avail.  http://blogs.microsoft.co.il/blogs/itaysk/archive/2007/04/05/InfoPath-_2D00_-Get-the-current-user-without-writing-code.aspx Attached is an example ...

Yes it makes total sence, thank you!

Hilary, Thank you so much!  I see what you did but why did that fix it? Is it because the rules only run on update to the field.  So you would check off the box, the rule would run but there was nothing in the Unit field.  So you added the rules to the unit field so when the unit field is updated the rule runs again?

Hillary I do need your help.  If you open the link below (I see no way of attaching files in this forum) you will see what the issue is.  There are several rows in the form just like this one.  The user checks off a row and then populates the number of unites.  The last field is the total of Hours / Units.  A rule ...

Hilary that worked, but I have developed another issue, unrelated to the first.   Field A / Field B = Field C  Returns Error "Infiniti" Not sure why this is happening. If A = 4 and B = 2   C should = 2 But I get an error.  If I go into the text box properties of C and put in the formula ...

Having an issue trying to write a formula for a field. I have three cells A B C A = Hours for Job 1 (there will always be a number in this field) B = Hours for Job 2 (there may not be an entry for this field) C = A + ((B+A) /.5) The issue comes in when there is no entry for field B (B =0).  Then I get NaN ...