RE: Incrementing data and storing in field

Tech-Archive recommends: Repair Windows Errors & Optimize Windows Performance

Did you test the 'maximum control_source + 1' in a query?
--
Build a little, test a little.


"paduanow" wrote:

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

It stays a 1 all the time.
--
pad


"KARL DEWEY" wrote:

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.

--
Build a little, test a little.


"paduanow" wrote:

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?

--
pad
.

Relevant Pages