Order of Records Presented in Form

[ZoeAbby]

Hi,

This has to be a very easy fix...but I can't figure it out. This is really two questions.

1. I have a form that displays the results of a table. Users are also allowed to enter a new record. Currently, the records are presented in reverse chronological order. I would like for them to be presented in chronological order so that the latest entry will be visible above the blank record. How do I do this simple task?

2. Conversely, it would really be best if I could make the empty record show up at the top of the screen with the existing entries visible below the empty record in reverse chronological order as they are now. Can this be done?

 

[BLeslie88]

well...

First off... In your forms recordsource...

Just invoke a query. and order it any way you wish....

Secondly... about the adding records on top.... Dun think there's a way on a bound form...

I will keep an eye on this message to see it there is though.

 

[ZoeAbby]

Thanks, I don't know why I could not find the proper location to sort, but I did. At least I have them in a usable order now. Thanks so much!