Insert Record / New Record on Top of Table

[Michael Kintner]

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

 

[Al Camp]

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

 

[Roger Carlson]

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/wa.exe?SUBED1=ACCESS-L