• The order of records being displayed on a form is determined by the record source for the form - so if your form has a SQL statement as its record source, and that statement has an ORDER BY clause, then the records will be displayed in that order. So if you want to change that order based on changes in the data or some other external source, you have to at a minimum refresh the form using either a macro or VBA, or in some cases you may need to dynamically change the record source in VBA. Hopefully that is enough to get you started.

    Wendell
    Colorful Colorado
    You can't see the view if you don't climb the mountain!