Sort the Blank/New Record to the Top

[Clint Marshall]

In an Access form, we have many detail records which are listed in a
subform. The detail records are sorted with the most recent at the top, but
when we want to add a new record, we have to scroll to the bottom and can no
longer see our notes from the most recent record.

Is there a way to have the blank, new record in the subform appear at the
top of the list of records, rather than at the bottom?

Thank you!

 

[Roger Carlson]

On my website (www.rogersaccesslibrary.com) is a small access sample
database called: "ContinuousFormWithNewRecordOnTop.mdb" which illustrates a
couple of ways to do this.

--
--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