• That helps consisderably. It appears that you really want to sort the display by the Description column then. (It also appears that either Access or SQL Server thinks that "Description" is a reserved word - you might want to edit the column name to something like "txtDescr" to prevent possible problems.) Since that is a varchar(200) you are going to get an alpha sort rather than a numeric sort - is that field always going to be numeric? You could try adding an "ORDER BY Description" and see if that works. How is the value of the Description field set? By the user, or by some logic on the form? Note that Access forms always add a new record at the bottom of the form, so unless you add logic to resort the recordset after each new record, the display will no longer be sorted the way you want.

    Finally, one note of caution about using the .ADP format. Beginning with Access 2013, that format is no longer supported, and in both Access 2007 and Access 2010 there were no enhancements beyond what was in Access 2003.

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