No Running Sum (Access 2002)

[danny2000]

Hi
I have form with a textbox of which I wish to increment records.
If I use 'Autonumber' it will increment the record but shows "Autonumber" in the new records before I add any data and I don't want that.



I understand access 2003 has a 'Running Sum' Property but I have access 2002 and it doesn't seem to have this.

Is there any way to increment my records (showing in a text or combobox) which doesn't require miles of code? I want the numbers to re-adjust if I delete a record so that all serial numbers are unique.

Is there a property which will allow me to do this?

Thanks
danny2000

[June7]

Running sum not a property for control in form, there is for report, but not sure if 2002 has it. Look for RunningSum property in textbox on report. If you find it, set it to yes and ControlSource to =1.

Anything else requires code as far as I know, look at http://www.lebans.com/rownumber.htm

Why do you need this in form?

[danny2000]

There is not a property for control in form, there might be for report, not sure if 2002 has it. Look for RunningSum property in textbox on report. If you find it, set it to yes and ControlSource to =1.

Anything else requires code as far as I know, look at http://www.lebans.com/rownumber.htm

Why do you need this in form?

I just wanted this for a reference in a form. I'm basically entering an acronym and a description and want to number them.

I think I've found a solution though. Just in case anyone else needs this I've used the 'CurrentRecord' property. It's exactly what I was looking for. I use this in a form event 'On Current' so when I select a new record the serial is automatically updated.

Thanks for the response.

me.text1.value = form.CurrentRecord