Access Form Does Not Open to Last Record - Opens to Earliest Record

[sleake]

I put the following code in the On Load event of this form: DoCmd.RunCommand acCmdRecordsGoToLast
It opens with records created in March 2014 at record 46, and ends with records created in December 2014, at record 1, using the navigation buttons. I've compacted the database, decompiled the code, and recompiled. I really need to have the form open to the most recent record.

Any suggestions?

[orange]

If you want the latest(Date) record, then use a query that specifically looks for Max(datefield)
[code
SELECT your fields FROM yourtable
WHERE someDateField = (SELECT Max(someDateField) FROM yourtable)
[/code]

There is no order to records in a table. If you delete a record, that space could be used by another record.

[June7]

Do you have descending date sort order set on the form?

[Missinglinq]

Do you have descending date sort order set on the form?

That certainly sounds like the problem!

Linq ;0)>

[sleake]

I tried setting the Order By on the form to descending on the create date (entered automatically) and the auto-numbered ID, and another date field. None worked. So I went to another database I created where it does go to the last record of over a thousand records.

Private Sub Form_Load()
 
    DoCmd.GoToRecord , , acLast
   
End Sub

That didn't work until I deleted the Order By line in this database, and voila, opens to last record. The Order By line was obviously conflicting with the "go to last code" I stated in the first post.

I appreciate your responses. Don't know why the Order By doesn't work, but am happy with the solution. The first solution offered did go to the last record, but filtered by the Where clause. I need to be able to page back a few previous records to record certain information.

Thanks for your time and generosity.