Incrementing data and storing in field

[paduanow]

I have a field call control_source that is a numeric field. I want to
increment the field by one for every saved record. I could use an Auto
number type but I must have 20 digits stored and the auto number type does
not allow for lead Zeros. Lead 0s are a requirement. I have an auto number
field called ID.

So I tried to add 1 to the control_source field On Click Save button by
control_source = ID + 1 (my C program habit)

I know this does not work. Is there a simply syntax I am missing. I want
to put this into a procedure if possible. Do I need to write a function?

 

[KARL DEWEY]

I have a field call control_source that is a numeric field. ... Lead 0s are
a requirement.
A number field does not have leading zeros. You must have a text field or
you are formating the number field into a string with leading zeros.

You can use BeforeUpdate event to pull maximum control_source + 1 for the
text box.

 

[paduanow]

I understand that I must have a text field. But it still did not work.

It stays a 1 all the time.

 

[KARL DEWEY]

Did you test the 'maximum control_source + 1' in a query?

 

[paduanow]

I got it, but I did use the auto number type and put the 20 lead zeros in the
format
location.

thanks Karl.

 

[KARL DEWEY]

You do realize that autonumber may not be sequential.

 

[paduanow]

Yes, as long as they are not the same.
--
pad

You do realize that autonumber may not be sequential.