Insert Record / New Record on Top of Table

Is there a way that you can setup the tables to have the insert record/new
record at the top of the list vs the bottom?

Thank you in advance for your help,
Mike

No... New records are always appended to the end of the dataset, regardless
of sorting.
hth
Al Camp
Candia Computer Consulting - Candia NH
http://home.comcast.net/~cccsolutions

"Michael Kintner" wrote in message
...
Is there a way that you can setup the tables to have the insert record/new
record at the top of the list vs the bottom?

Thank you in advance for your help,
Mike

No, you can't set up tables to do this, but you can create a form with a
subform in continuous view where you can put the New Record on the top.

On my website (www.rogersaccesslibrary.com), there is a small Access
database sample which illustrates this:
"ContinuousFormWithNewRecordOnTop.mdb"

--Roger Carlson
Access Database Samples: www.rogersaccesslibrary.com
Want answers to your Access questions in your Email?
Free subscription:
http://peach.ease.lsoft.com/scripts/...UBED1=ACCESS-L

"Michael Kintner" wrote in message
...
Is there a way that you can setup the tables to have the insert record/new
record at the top of the list vs the bottom?

Thank you in advance for your help,
Mike