Hi

I have a function which compares the value in two tables. I retrieve the first value from 1 table then loop through another table and look for that value. Once the EOF in the second table is reached it should move on to the next value in the first table. Can I test this ie can I avoid having to F8 through 1000 records whilst debugging?

Cheers
Tony

__________________
Cheers
Tony

Make a "test table" for yourself that is a subset of your 1000 record table.

Or restrict your recordset with sql.

ex. If there are dates do a date range WHERE date1 BETWEEN beg_date AND end_date