How to enter data without changing the numerical order?

[Pingwin via AccessMonster.com]

How to enter data without changing the numerical order?
Let say I've got rows called:

ID OrdNo Surname
56 1 Adamson
67 2 Beck
34 3 Carson
55 4 Dobson
34 5 Erickson

Now when user fills the form with new name it will look like this:

ID OrdNo Surname
56 1 Adamson
67 2 Beck
34 3 Carson
68 0 Crackmayer
55 4 Dobson
34 5 Erickson

Is there any way to make a look like this?

ID OrdNo Surname
56 1 Adamson
67 2 Beck
34 3 Carson
68 4 Crackmayer
55 5 Dobson
34 6 Erickson

Any help would be greatly appreciated.
Many thanks in advance!

 

[S Panja]

Apparently OrdNo is functioning like SerialNo, in which case it need not be a
field in the table; you can generate the same in the report.
--
***************************
If the message was helpful to you, click Yes next to Was this post helpful
to you?
If the post answers your question, click Yes next to Did this post answer
the question?

 

[Rick Brandt]

How to enter data without changing the numerical order?
Let say I've got rows called:

ID OrdNo Surname
56 1 Adamson
67 2 Beck
34 3 Carson
55 4 Dobson
34 5 Erickson

Now when user fills the form with new name it will look like this:

ID OrdNo Surname
56 1 Adamson
67 2 Beck
34 3 Carson
68 0 Crackmayer
55 4 Dobson
34 5 Erickson

Is there any way to make a look like this?

ID OrdNo Surname
56 1 Adamson
67 2 Beck
34 3 Carson
68 4 Crackmayer
55 5 Dobson
34 6 Erickson

Any help would be greatly appreciated.
Many thanks in advance!

Tables have no (reliable) order. If you want to see the data in a particular
order use a query, form, or report that has an explicit sort applied to it.

 

[Rick Brandt]

Tables have no (reliable) order. If you want to see the data in a
particular order use a query, form, or report that has an explicit
sort applied to it.

Actually, looking at thia again I see I misunderstood your issue. It appears now
that you want to re-shuffle the value given to OrdNo as records are inserted
according to an alphbetical listing of Surname.

Can you explain why you want to do this? Why not just eliminate that field and
sort on Surname?