New record at top of continuous form (1 Viewer)

[Neal]

Does anyone know of a way to make a new record appear at the top of a continuous form? I have set the record numbers to sort descending, but when I want to start a new record, I always drop to the bottom of the recordset.

 

[llkhoutx]

AfterUpdate on the new reqcord, requery your form. It will puts your records, all of them, in descending order.

New records are added to the end of the recordset, the requery rearranges them.