Order By Highest First?

[ChrisHaynes]

Hi, I have a form (frmRegistryFiles) and need to show records in order of the highest value first in one of the fields. The field is 'RegNo' and contains 4 digit numbers. I need the highest reg number to show first, then next highest and so on. I know there is an 'Order by' property on the form, but how do I do this?

How can I do this?

Thanls in advance,
Chris.

 

[Remou]

How about:
Me.OrderBy = "RegNo DESC"
Me.OrderByOn = True

 

[ChrisHaynes]

Hi Remou, that's perfect, thanks alot.


Chris.