order in Recordset

[Wouter]

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

[R@emdonck]

Hi,

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

R@emdonck