Reverse Auto Number field?

Posted on 2005-04-14
Last Modified: 2012-06-27
I have a form linked to a table containing an auto number field primary field. Upon creating a new record via the form an auto number is generated. However, if the user decides to back out of the record and not save it the auto number remains incremented even though there will be no entry in the table. Is there any way to prevent this from happening or am I best off using code to generate my incremental number?

Question by:IMD1
    1 Comment
    LVL 44

    Accepted Solution

    1)once an autonumber value has been used, even if the record is subsequently discard, the number is lost and cannot be 'reclaimed'

    2) you should NEVER use an autonumber field for a value that has SIGNIFICANCE (such as a receipt number, or an invoice number).  If you need a field that MUST be kept strictly sequential, then you will need to manage that sequence number yourself, in code.


    Featured Post

    Find Ransomware Secrets With All-Source Analysis

    Ransomware has become a major concern for organizations; its prevalence has grown due to past successes achieved by threat actors. While each ransomware variant is different, we’ve seen some common tactics and trends used among the authors of the malware.

    Join & Write a Comment

    Suggested Solutions

    The first two articles in this short series — Using a Criteria Form to Filter Records ( and Building a Custom Filter ( — discuss in some detail how a form can be…
    QuickBooks® has a great invoice interface that we were happy with for a while but that changed in 2001 through no fault of Intuit®. Our industry's unit names are dictated by RUS: the Rural Utilities Services division of USDA. Contracts contain un…
    Familiarize people with the process of utilizing SQL Server functions from within Microsoft Access. Microsoft Access is a very powerful client/server development tool. One of the SQL Server objects that you can interact with from within Microsoft Ac…
    Access reports are powerful and flexible. Learn how to create a query and then a grouped report using the wizard. Modify the report design after the wizard is done to make it look better. There will be another video to explain how to put the final p…

    728 members asked questions and received personalized solutions in the past 7 days.

    Join the community of 500,000 technology professionals and ask your questions.

    Join & Ask a Question

    Need Help in Real-Time?

    Connect with top rated Experts

    18 Experts available now in Live!

    Get 1:1 Help Now