Last record first

[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.

 

[fredg]

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.

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

 

[Alex]

-----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

 

[Bob]

If you want the newest record to appear first, sort by
your autonumber field in descending order such as:

Order By MyAutoNumberField DESC