Order By

[Peter]

Hi again...

In the Form property sheet i am setting Order By "ID ASC"...but nothing
happenes...this is a continous form beased on table...and i want next record
to appear first..

Thanks!

 

[Douglas J. Steele]

The new record will always appear at the end, regardless of the seeting of
ORDER BY. (and if it were possible, wouldn't you need to sort DESC, not ASC,
to get the latest one at the top of the list?)

 

[Peter]

Thanks Douglas, you are right!...geee..must be the age...thanks again!

 

[Douglas J. Steele]

BTW, one approach to having the new record at the top of the list is to use
two separate subforms.

Make the top subform 1 row high, and set its DataEntry property to True, so
that it only shows a new row.

Make the bottom subform as high as you like, and set its AllowAdditions
property to False, so that you can only add data in the top subform.