Sorting Dates on Forms

[bquan]

My forms have several fields where historical data for a client is kept. We need to update it often with a "open date (to certain program)" and a "close date (to that program)" I would like that once we look up certain client in the form, we see the most current "open date" to a program. Our data entry person will then add a "close date" and a new record "as another open date for a new program" So, how can I sort a table field so that the most current open date is listed, and that once the person hits a new record and a new open date is entered, it will show next time the database is updated? Thanks for your help!

 

[Rich]

Sort the open date Descending

 

[bquan]

Thank you for your prompt reply. But, where do I do that? I have tried to to it in the table, but when I open the form, it does not change it. Also, I could not find a place to sort in the actual form. Could you advice? Thanks

 

[Jack Cowley]

Create a query based on your table. Sort the date field in descending order in the query. Base your form on the query.

 

[bquan]

Thank you so much for your help! I tried the queries and it worked!