Me.Filter and make records appear in descending order?

[kate10123]

Hi there,

I have a student form which is used to enter data about students. I have added a couple of filter buttons so it is easier for the admin team to find blank fields to carry on entering data.

Ideally though, I want the filter to also show the records in descending order by created_date so that the most recent record shows first.

Here is my current filter:

Me.Filter = "Ethnicity is Null"
Me.FilterOn = True

How would I say BY Created_date.Descending?

Thanks

Kate

 

[pbaldy]

Check out the OrderBy property.