Seapeace
There's something wrong here... an autonumber field can be sorted on,
just like any numeric field.
What do you mean by that. Please describe your autonumber field, your
table, and what you mean by "disappears."
Also... it's best not to work in your table. Create a query, or even
better, a form to view, edit add, delete to your table.
--
hth
Al Campagna
Microsoft Access MVP 2007-2009
http://home.comcast.net/~cccsolutions/index.html
"Find a job that you love... and you'll never work a day in your life."