how do i know a record number?

[omer555]

Hi!
I am accessing the access database with the use of declaring objects like

dim db as database and
dim rs as recordset and then i open the database using a query like 'select * from blah' my question is dat is there any way i can come to say 5th record after i run the search query for a particular record?

[mpSmooth]

try using the absolute position property

[omer555]

Actually i tried it.Is there any way dat i can save the state of a table after a query is executed on it and return to dat state again after 2 or 3 queries have been executed through VB code?