New Record in DataSheet

J

JamesJ

I've been delving into Split forms lately and was wondering if there was
a way to display the recordset's new record in the top row of the datasheet?

James
 
O

Order2Chaos

Depending on how you sort your data it shouldn't be too bad.

Using a standard Auto-Number ID field, I would set the datasheet side to
order Largest to Smallest, which will show the latest entry at the top down
to the first entry.

However, as you add them it will slot them down the bottom, so you could try
adding in the after update event macro Requery. This will cause the list to
resort itself after updating the selected field.
 
Top