Datasheet Display order

[Parkroyal]

I have a subform displayed in datasheet view.

By default it displays records in assending order. How do I change this so that I get the latest record at the top of the list?

I've tried using the 'Order By' property but I can't seem to get it to work.

Any ideas?

Pete

 

[jimb0ne]

form is based on a query and you want the most recently added record to be at the top? am I reading your right?

 

[Parkroyal]

JimbOne

Doh!

You just answered my question for me. Yes it is based on a query -- I just need to sort the ID field in the query --- Just me brain needed a poke.

Many thanks

Pete