Shoot... I forgot about the index. There is a sort option on the form; I just hadn't used it when I was trying to make this work. This is getting way too complicated for something that I thought was a two minute mod. :)

My original thought was to use an artificial counter. Sounds like that might be the best way to go.

Thanks,

Michelle


>OK my post got messed up because of "<". So here it is again. I don't know html that well and I guess "<" is not a character that can just be typed in a post.
>
>In my answer I will refer to "X of Y" instead of "X of X". The question you are asking is how to find out what "X" is. "Y" is easy, as you have stated it is a record count of the non-deleted records. As I see it "X" is really variable depending on how the table is ordered. But it sounds as if you are just using physical table order. So I would do something like:
>
>lnRecno = recno()
>count to lnDeletedRecs for deleted() and recno() "<" lnRecno
>DisplayValue = lnRecno - lnDeletedRecs
>
>Of course if the table was ordered using an index than that would be a whole other set of code.