Autonumber increments even though 'cancel' is selected

[TAM]

I have an autonumber on my table to assign each record a value. When the user hits cancel, the form doesn't save -- which is great -- however, I noticed that when I create a new record, I noticed that the autonumber still incremented. Is there a way to prevent the increment if the user hits cancel and exits the form?



Example: Record_nmber =40 and user hits cancel; next form the record_nmber is 41. I want it to be 40 since that record number was never created.


Thanks!

[nick404]

I'm not entirely sure if you can, but, it doesn't affect anything if the autonumbers aren't consecutive or go out of order. They will never repeat and that is all that is necessary for their purpose assuming this is your PK.

[ItsMe]

The short answer is no. Autonumber is assigned to the record before the record is saved and committed. If the record is not committed the number that was assigned to the Autonumber field will not be used again.

You would have to do a compact and repair to start again with the next available number. For this reason and a few other reasons Autonumber is not used for sequential numbering. Autonumber is for creating Unique values for identifying records.

[orange]

TAM,

See this for info on Autonumbers -What they are not

[TAM]

Thanks, everyone. Helpful info!