Increase Field value by 1 on Open form

S

Steve

then I'm trying to calculate the maximum value for a field and add 1 to it
and display this in a field on a form, when it is opened.
 
J

John W. Vinson

then I'm trying to calculate the maximum value for a field and add 1 to it
and display this in a field on a form, when it is opened.
Click to expand...

=NZ(DMax("[fieldname]", "[tablename]")) + 1


John W. Vinson [MVP]
 
S

Steve

Thanks a bunch John. Works great

John W. Vinson said:
then I'm trying to calculate the maximum value for a field and add 1 to it
and display this in a field on a form, when it is opened.
Click to expand...

=NZ(DMax("[fieldname]", "[tablename]")) + 1


John W. Vinson [MVP]
Click to expand...
 
Top