InfoPath Dev

I have a form that is submitting both to a database and SharePoint Document Library. Once submitted to the database, another user will pull the form up in SharePoint to make changes and resubmit back to the database. 

I have the SharePoint name  generated by a concatenation of a AddedToTable Date which I have set to Now() and an ID field.     I need the date not to change after it is first submitted but my date keeps changing.  How can I get the initial date not to change so that my SharePoint document name doesn't change?  I want any changes within the form saved back to the same document.

I've searched the forums and I can't find what I need.  I need a solution that doesn't require code.

Thanks

You just need to add a field to your form which saves the original file name.

Have a rule on open which if filename is blank, sets is to your concat (addedtotable, ID).  Then in your SP submit use this field as the file name.

On subsequent opens since it has a value the file name will not change.

On your exisitng forms you will need to manually set this since you want to retain the original file name but on any new this solves your issue.

Another option is to query the document library and maybe look for you r user's name if you identify the user and the most recent file they have opened.

I use the same scenario in some of my forms.  I want the time found that the form was originally set.  I have a txt box that is called requestTime and the default value is set to now.  However like you said it recalculates each time the form is opened.  I just uncheck the text box that says: Update this vealue when the result of the formula is recalculated.  That solves the problem, and the time is only created when it is initially opened as a new document. 

Also ensure in your dataconnection to sharepoint that you allow it to over write existing files.

That worked.  It took a little while because I had several rules for submit so I had to rearrange the order a little.  Thank you.  I've been trying to figure that out all week.

Thanks