autonumber in access not starting at 1

[b.saimsc]

I have Created a form and 1st field SL_NO given as Autonumber it's works fine but everyday i have delete old records and enter new records in that form...my problem is it's always starts with after old record number.

Ex : yesterday i had enter 50 records and today i have deleted those 50 records and started my work but it's continuing with 51 only....Please help me......

[Bob Fitz]

I believe this is normal behaviour and should not be a problem if you are using the Auto-Number feature correctly. It is not meant to represent any meaningful data. It is just a unique identifier for each record. It is not necessarily sequential and can even produce negative numbers. In A2003, doing a Compact and Repair 'resets' the Auto-Number.

[b.saimsc]

How to reset AutoNumber? I need sequential please help me..............

[Bob Fitz]

As I said in my last post Auto-Number is not necessarily sequential. To create your own sequential number see: http://www.599cd.com/tips/access/inc...r-own-counter/

[b.saimsc]

Hi Bob
Thank you for your earliest response i really appreciate your comments.....As your suggestion i have gone through your link and i have followed but i am getting different result i.e All records represents same number means 1 only....here the formula please help me....
formula:
Private Sub Form_BeforeInsert(Cancel As Integer)
SL_NO = Nz(DMax("SL_NO", "Nasco Production")) + 1
End Sub

Thank you...........

[Bob Fitz]

I can't see anything wrong with the code you have.
Can you try the code below and tell us the values shown in the message boxes.

Private Sub Form_BeforeInsert(Cancel As Integer)
  Msgbox Nz(DMax("SL_NO", "Nasco Production")) 
  Msgbox Nz(DMax("SL_NO", "Nasco Production"))  + 1
  SL_NO = Nz(DMax("SL_NO", "Nasco Production")) + 1
End Sub