Order By

  • Thread starter Thread starter Peter
  • Start date Start date
P

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!
 
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?)
 
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.
 
Back
Top