Last record first

  • Thread starter Thread starter Alex
  • Start date Start date
A

Alex

Can anyone tell me how to program a form so that it opens
the last record (blank record) first, then back in order
of entry.

e.g.

First record opened in form: blank
Second record opened in form: Record #2
Third record opened in form: Record #3.

Thanks,
Alex.
 
Can anyone tell me how to program a form so that it opens
the last record (blank record) first, then back in order
of entry.

e.g.

First record opened in form: blank
Second record opened in form: Record #2
Third record opened in form: Record #3.

Thanks,
Alex.
Click to expand...

To always open the form to a New record, code the form's Load event:
DoCmd.RunCommand acCmdRecordsGoToNew
 
-----Original Message-----


To always open the form to a New record, code the form's Load event:
DoCmd.RunCommand acCmdRecordsGoToNew


--
Fred
Please only reply to this newsgroup.
I do not reply to personal email.
.
Thanks very much
Click to expand...
 
If you want the newest record to appear first, sort by
your autonumber field in descending order such as:

Order By MyAutoNumberField DESC
 
Back
Top