SharePoint Auto Numbering in InfoPath 2007

I am trying to Create a Purchase order form using InfoPath published thru Sharepoint

So I download the Purchase order Template from Microsoft download and tweaked it.

Now i needed to create a Recurring number sequence .. So I found this web site to help me 

Now It seems to work fine. it names the files and adds a number after each one, great..
but when i open the file I dont see the number I get a fasle in the text field. instead of the number  
Who is Participating?

[Product update] Infrastructure Analysis Tool is now available with Business Accounts.Learn More

I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

melli111SharePoint Administrator / DeveloperCommented:
Could you possibly post your form here so I can take a look at it?  Make a copy of the form and change the file extension to .txt and then attach it to a new comment here.
gotti777Author Commented:
here you go

I have some rules for submit that create the numbers..
melli111SharePoint Administrator / DeveloperCommented:
Ok I see the problem... In the formula (on the rule on the submit button to set the value of the autonumber field) you have "autonumber = max(@ID) + 1"..... you don't need the "autonumber = " part... just the max(@ID) + 1.    Having the autonumber =  in the formula is checking to see if the autonumber field is equal to the max ID + 1... which returns a false value.  Get rid of that and you'll be good to go  :)
10 Tips to Protect Your Business from Ransomware

Did you know that ransomware is the most widespread, destructive malware in the world today? It accounts for 39% of all security breaches, with ransomware gangsters projected to make $11.5B in profits from online extortion by 2019.

gotti777Author Commented:
Well i removed the autonumber = max  
it still names it right  but now when i open it it always reads a 5

melli111SharePoint Administrator / DeveloperCommented:
Hello, you actually didn't want to remove the max - you need the max part.  In the value from your screenshot above change it to look:

max(@ID) + 1

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
gotti777Author Commented:
Perfect thanks....
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today

From novice to tech pro — start learning today.