Max(.)+1 results in NaN

[Lupe]

Hey there,

I've got an Infopath form linked to an Access DB. When I start a new
form I'd like one of the text boxes to be auto-filled with the next
sequential number for a field.

I've tried setting the default value to max(fieldname) + 1" but that
result's in NaN. and if i just try "max(fieldname)" the box is blank,
so i'm not sure it's querying the db?

Am I doing something wrong or is there another way to get incrementing
numbers in Infopath?

Any advice would be greatly appreciated,
T

 

[Jesper]

Hi Lupe!

Take a look at the link below - it solved the same problem for me.

http://www.infopathdev.com/howto/tutorials/default.aspx?i=d663d7df90e94e65abb02632966e8127

Best regards,
Jesper

 

[Lupe]

Thanks for the reply Jesper!

I'm fairly new to formulas and i'm having a bit of trouble with that
one.

"count(../preceding-sibling::my:Row) + 1"

if my Table was named "BookIn" and the field I would like to auto-fill
was "RefNum" which fields would i replace in that formula?

I apologise for my ignorance