Autonumber ?

[amfroehlich]

I have a field that is autonumbered, when i access that field in a form it pulls the next number. But, if i don't add the information to the database it still stores that number in "Never Never Land" and it can't be used to continue the sequence. Why? Can I stop this? How?

 

[bmacr]

I have a field that is autonumbered, when i access that field in a form it pulls the next number. But, if i don't add the information to the database it still stores that number in "Never Never Land" and it can't be used to continue the sequence. Why? Can I stop this? How?

If the sequence of the numbers is important to you, then Autonumber is not the right thing to use. Any time you delete a record, etc., that number is gone for good. You can get a number back, however, if it is still the last one, meaning you haven't added a record after it yet. You just compact and repair the database. Autonumbers are meant only to be unique, not to have any particular value or sequence.

 

[bat17]

I pointed out this hazard of Autonumbers to you on you other question about them.
http://www.mrexcel.com/board2/viewtopic.php?t=104348&highlight=autonumber



Peter