how to check if a already pass a record??

how can i find out if i m on the last or the first record of a recorset ??? I do not want the BOF and EOF properties these do not represent the last-first record

You will need to get a proper recordcount first. Do this as follows:



myRecSet.MoveLast
myRecSet.MoveFirst





Then you should be able to use BOF and EOF