I know that you can view records in order by using the ORDER BY clause in a SQL statment, but how can I sort the records in the table via code so that the records will be in order when I bring it up in Access? Now it shows up at the end when I put the new entry into the database. BTW, I am using ADO to do this.

Thanks,
Todd