Thanks .... now i am using the Autonumber field and its working...

Regards
Nash

Hi

I am new to V.B . currently i am using MS-Access as backend and V.B 6.0 as front end. now i am creating one table in MS-Access with fields SName and SAge and i entered 15 records with out any order.
now i am trying to access those records using ADO recordset.its working fine.. but it shows last 14 records in first position and first record in the last position. so what i have to do to access all the records in the same order...