>If I am on a specific record for an employee, and then filter, will I still be on the same record after I filter or will it put me on the first record in the filter.
>
>Example: If I am on the secord record for the employee, will I still be on that second record when I filter?
>
>Thank you so much for your help.
Christine
In order for a filter to work you must move the file pointer, so you won't be on the same record, unless you first store the Recno(), then goto that rec # after the move. e.g.
lnRecNo = RECNO()
Set filter to {whatever}
Locate
Goto lnRecNo.
Now then, as to which is faster - select or filter - that you could determine yourself very easily with a timed experiment with both methods.
- Whoever said that women are the weaker sex never tried to wrest the bedclothes off one in the middle of the night
- Worry is the interest you pay, in advance, for a loan that you may never need to take out.