Math function (max) extracting information doesnt work

[gtheoulis]

I have a very weird glitch on Infopath.
I have a form on infopath that is published on a sharepoint site. in this
form there is a field where each form gets a number once approved. this
number is a sequencial increasing by 1 for every form submitted.
The very first form was set manually (ex 1).
I have a control button for setting this auto number. the formula is as
follows:
max(@ECR__) + 1
where ECR_ is from a data connection from the form library that refers to
the form field ECR which we are setting this auto number.
This method worked great for a few months, and now stopped working. it now
returns the same number everytime.
I have looked at everything and cannot find any problem.
Looks like a glitch, anyone have a fix for this??

thanks
Gus

 

[S.Y.M. Wong-A-Ton]

If it worked great for a few months and then suddenly stopped working, I
would not look for the problem within InfoPath itself, but rather conduct an
investigation as to what has changed (installed anything lately? made any
other changes to the system?) since it stopped working.

 

[gtheoulis]

there were no system changes when the problem occurs (not that i am aware
of). what kind of system changes could cause this sort of thing?
Yesterday evening the auto numbering started working again.......go figure