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.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

GoToRecord on Split Form with Hidden Fields 0
Use VBA to switch view in Split Form 5
Action on record change from split form? 2
Sync/Link 2 forms 2
Split Form - Rows Missing in Datasheetafter UNDO of Delete 3
Datasheet shows no records in split form in Access 2007 runtime vi 1
datasheet view 3
Unremovable horizontal scroll bar on subform 1

Back
Top