A
And
Hi everyone!
I have this problem that I am trying to solve for a few days.
In a form I have a text box in which I want to have a sequential number
depending on the biggest number of this field. This field can't be of the
auto number type since it must be able to have changes.
I tried to solve this in this way:
I put in the default value of the control the expression:
Max([field])+1. But this only worked if I have another control with that
value: (Max([field])+1) and only if I add one record each time.
Can someone help me
Tks in advance
Andy
I have this problem that I am trying to solve for a few days.
In a form I have a text box in which I want to have a sequential number
depending on the biggest number of this field. This field can't be of the
auto number type since it must be able to have changes.
I tried to solve this in this way:
I put in the default value of the control the expression:
Max([field])+1. But this only worked if I have another control with that
value: (Max([field])+1) and only if I add one record each time.
Can someone help me
Tks in advance
Andy
