subform new record entry

[Guest]

I have a subform that has records entered into it. Eventually, there will
1000's of records listed. When it comes to enter a new record, the user will
need to scroll to the bottom (way down) to get to the new record line. The
subform is in descending order so the most recent entry is always at the top.


Is there a way to have the new record entry at the top of the list?

Thanks.

*** John

 

[Guest]

How will the table know which is the first record and which is the last
record? Access doesn't care about order unless you put in a time or date
stamp.

like default to

=date()

or

=now()

Alternatively, when you open the form you can send the cursor directly to a
new record. Use a "gotocontrol" commands for the subform and a "gotorecord":

docmd.gotocontrol
docmd.gotorecord , , acnew