order in Recordset

How can I make the order in a Recordset the same as the order in a table. In my case the order indexes (Autonum) of the rows in the table are 1,2,3,4,5,6 but the order of the indexes in the recordset is 1,2,5,6,3,4, how can I make that the recordset has the same order as the table?

Regards
Wouter

Hi,

When you request your recordset with an SQL statement, you can use the "ORDER BY" statement to get it righ.

R@emdonck