Location of new record line when in datasheet view

[cricketbird]

On a subform that records notes in datasheet view (columns: Date, Note; sorted in reverse chronological order with newest at the top), is there a way to get the blank new record line to appear at the top? Otherwise, you have to counter-intuitively scroll down below the oldest entry to enter a new line.

We could sort in chronological order, but then the most relevant notes would sometimes be scrolled off the bottom of the form and not seen.

Thank you,
CB

 

[CJ_London]

regret there isn't.

What you could do is have a button to add a new record which has the following code.

me.dataentry=true

this will 'hide' the existing records

then in the form afterupdate event have

me.dataentry=false

which will redisplay all the records

 

[cricketbird]

Actually - that is perfect because there are a few other actions I would like to capture when adding a new item!

Thank you,
CB