Sorting Databse Records

[VB_Novice]

Hello,

I am using VB 5 as an interface to an Access 97 database. When I add a new record to a table through the VB interface it goes to the Access table no problem and is also sorted correctly in this table.

However, when I view the records in the table using the VB interface they are not sorted and the record which has just been added is shown as the last record, even if it's primary key has a lower value than the previous record.

Is there any code I can use to sort these records, so when viewing through them in the VB interface, (after new records are entered), they will be sorted as in the Access table.

Hope someone can help,
Thanks,
Andrew

You can use ORDER BY in a SQL statement that you used in your recordsource propertie of your database object or references.

-Kayoca Mortation