Luis said:
I want to re-number rows after deleting records, so there's no skipped
numbers and I can always tell the real quantity of names or entries there
are.
The is the answer to your question and the answer to your REAL question.
Answer toyour REAL question:
It appears you have an autonumber field that is providing you with
numbers. I suggest you may not want to use Autonumber for that use.
Autonumbers are designed to provide unique numbers. It in not designed to
provide numbers in order and for a number of reasons may not do so. As a
result using them in any application where the user sees the numbers is
likely to end up with confusion.
There are other ways of providing the numbers you want depending on the
particual application. In most forms you will see the total number of
records at the bottom of the form.
As for your question, you need to "compact" the database then delete the
autonumber field and add a new one. This could mess up things if you
existing autonumber field was being used to link to another table. In that
case you could create a second autonumber field and hide the first one.
