New Record in DataSheet

  • Thread starter Thread starter JamesJ
  • Start date Start date
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
 
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.
 
Back
Top