View Full Version : Descending order in datasheet view of subform


vangogh228
05-16-2002, 04:21 AM
I have a subform for notes in which I would like a reverse-chronological order. I have gone to the underlying table and the datasheet view of the subform itself to establish this, done saves, and still when I view the subform within the main form, the notes are in regular order. When I view the datasheet view of the subform outside the main form, it does what I want.

My notes have and autonumber field, and I have done this procedure on the autonum field and the date field.

Help? Thanks!

Rich
05-16-2002, 07:13 AM
Sort Desc on the date field

vangogh228
05-16-2002, 08:17 AM
Rich: As I said in my orginial post... I did that already.

Jerry Stoner
05-16-2002, 08:31 AM
Change your Control Source to a query and sort desc there.