Fill a form field with the largest value+1 from a closed table?

[WinDancer]

I am trying to fill a form field with the largest value, plus 1, from a closed table.
I cannot get anything other than a error message.

the code in the unbound form field is:
max(tables!CustomPID!ID)+1)

Help, please?
Thanks,
Dave

 

[boblarson]

That would be DMAX

MyValue = DMax("ID", "CustomPID") + 1

 

[WinDancer]

Thanks, Bob. As always, it worked perfectly from the very first try.
Off to the next war...