sorting records in a form

[octatyan]

Hi, I have a form that displays "memo" records one at a time. Each record has a Memo id and a date. I would like the memos to be ordered from earliest date to most recent date. How would I do this?

Also, after this is done, when the form loads, I would like it to automatically show the record with the most recent date.

Any suggestions?

 

[dcx693]

Since it sounds like you'd like the form to open up each time with the correct sorting order.

The easiest way to do this is to base your form on a query and sort the query the way you want the records to appear in the form.

 

[Dwight]

I don't fully understand your question. The first and second part seem to conflict. It doesn't matter what order the items are stored in the table. As long as they can be uniquely identified which you said they can.

Just sort by the date field when the form is loaded. Then the most recent will be displayed first.

 

[Dwight]

Or you can follow dcx's advice. It is better than mine.