Show new record row in subform

[toppock]

Hi all,

I have a subform in which the users enter job update information. When an update comes in, they simply enter the information in the new record row, denoted by a * in the left hand column. Each record is timestamped (=Now()) and sorted by newest date first.

Is it possible to display the new record row (the blank one with the star) first? I attempted to add the Autonumber ID, hide it and sort by that but it simply comes up with "(New)" in the ID field.

Any help will be much appreciated. Thanks in advance!

Toppock

 

[pr2-eugin]

toppock, the (New) will become a Number only when the Form is dirtied. I would not suggest you to have new record as the start. Add records by click of buttons. If you always open in New record, might end up with several blank records for the parent ID, in the child table.

 

[toppock]

Thank you Paul. This makes sense. I will find another way around, cheers!