Include date sorting in a VBA filter button

[gojets1721]

Hi so my form has a button that when pressed, it filters down to certain entries. However when it filters, it no longer sorts the entries from oldest to newest by date. It's just randomly mixed up. Is there anyway to include something in the code that will sort from oldest to newest by date?

The VBA code that I am using for the button is:

Private Sub btnNotStarted_Click()
    DoCmd.ApplyFilter , "[Status]= 'Not Started'"
End Sub

 

[arnelgp]

Can you add to the code:

DoCmd.SetOrderBy "[Entry Date Fieldname] DESC"

 

[Pat Hartman]

Is the date sort in your RecordSource query?

 

[gojets1721]

That worked!! Thanks!

 

[Pat Hartman]

Which worked? It helps people who find this thread later to know what actually worked for you.