>>I have tried Recno( ), however it comes up with the record number of the underlying table record, not the record number of the cursor. I think it was from there. It wasn't a sequential series of numbers anyhow.
>
>I would suggest using RecNo(). Are you positive you are doing Recno() on the cursor? Maybe try a NoFilter on the end of the SQL SELECT? If you need to, do this, but you sohuldn't have to:
>
>private pnRec
>pnRec = 0
>
>select NextRec() as rec, * .....
>
>function nextrec
>return pnRec + 1

If the table is ordered the Recno( ) will not work, i.e., what is in the count column is not the same as the cursor record number. This is also so with NoFilter at the end. I will try the function.

Thanks for your help.

PB