>Sergy, thanks for your interest. I have a vfp6 app that I wrote a couple of years ago. Now, I want to filter the records to only show Furniture, Accessories or both (these are the 2 main categories of the furn. co.).
>
>I want the user to be able to filter at any time without losing their place in the dbf.
>
>I know that I could use a sql, but it would change the whole architecture of my program.
>
>Thanks, Randy
So what happens if the record they're currently on is "filtered out"? Your method of GO RECNO() would filter out other records that don't match the filter, but it would have no effect on the current record. You must move the record pointer to make the filter kick in.