incrementing recordID without using AutoCount

[Payson Books]

Where can I find some info on grabbing the recordID of the last record,
incrementing it by one, and using the new number in a new record.

[Allen Browne]

The highest existing record is:
DMax("recordID", "MyTable")

In the BeforeUpdate event of your form:
Me.recordID = Nz(DMax("recordID", "MyTable"), 0) + 1

Note that this could result in duplicates (not saved) if multiple users are
doing this at once. Using Form_BeforeUpdate delays this to the last possible
moment, and reduces (but does not eliminate) this risk.

--
Allen Browne - Microsoft MVP. Perth, Western Australia.
Tips for Access users - http://allenbrowne.com/tips.html

"Payson Books" <pr*******@lightspeed.net> wrote in message
news:AF**************@newsread4.news.pas.earthlink .net...

Where can I find some info on grabbing the recordID of the last record,
incrementing it by one, and using the new number in a new record.

[Tom Wickerath]

See article # 114 "Creating an Incrementing ID with Date Information" at
http://www.helenfeddema.com/access.htm
This was just published in a recent issue of "Woody's Access Watch" on 8/28/03.

Tom
________________________________________________

"Payson Books" <pr*******@lightspeed.net> wrote in message
news:AF**************@newsread4.news.pas.earthlink .net...
Where can I find some info on grabbing the recordID of the last record,
incrementing it by one, and using the new number in a new record.