restart auto numbering in an access database

A

Andriana

auto numbering in a form in access 2003 has missed a number. How to restart
numbering from the missed one to coincide with numbers on the task bar.
 
R

Rick Brandt

Andriana said:
auto numbering in a form in access 2003 has missed a number. How to
restart numbering from the missed one to coincide with numbers on the
task bar.
Click to expand...

That is not what AutoNumbers are intended to do and if you try to force them you
will only be disappointed. There are numerous, completely normal activities
that will cause gaps in an AutoNumber sequence. If you need a non-broken
seqential set of numbers then don't use AutoNumbers. Use code in your forms to
create your own.
 
Top