Reverse Auto Number field?

Posted on 2005-04-14
Medium Priority
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

Arthur_Wood earned 500 total points
ID: 13783590
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

Technology Partners: We Want Your Opinion!

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Code that checks the QuickBooks schema table for non-updateable fields and then disables those controls on a form so users don't try to update them.
A Case Study of using the Windows API to provide RS232 communications capability in Access without the use of Active-X controls.
With Microsoft Access, learn how to specify relationships between tables and set various options on the relationship. Add the tables: Create the relationship: Decide if you’re going to set referential integrity: Decide if you want cascade upda…
Add bar graphs to Access queries using Unicode block characters. Graphs appear on every record in the color you want. Give life to numbers. Hopes this gives you ideas on visualizing your data in new ways ~ Create a calculated field in a query: …

571 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