Form is not displaying newest record first

[JeroenMioch]

Dear programmers,

Ive been struggeling with this problem for a while now and since were now using Access 2010 i thought to give it another go.

When i pull up records using my filter it displays the oldest record first in the main form.
I know theres an option in the preferences to set things ASC or Desc, but this doesnt give the result i want.

Is there any way i can set my filter to do this for me by adding an extra line of code below ?

    Me.FilterPNummer.Requery
    Me.FilterNaam = ""
    Me.FilterKenteken = ""
    Me.Filtersticker = ""
    Me.Filter = "PNummer='" & Me.FilterPNummer & "'"
    Me.FilterOn = True

Any thoughts would be welcome

[June7]

Add an extra line of what code?

Why does ASC or DESC not give the desired result?

Filtering doesn't control order, sorting does.

Either set sort order in the form RecordSource query or in the Order By property.