3.8.4 QUERY LAST and FIND PREVIOUS

When your query fields are indexed, form searches the file in index order, otherwise form searches the file sequentially.

When you use QUERY FIRST, form starts the search just before the first matching record. As you press FIND NEXT, form finds matching records in the order described above.

To instead start your query after the last matching record, press the QUERY LAST function (GOLD <F1> followed by <F2>). Then, to find records in backwards order, press the FIND PREVIOUS (GOLD <F1> followed by <F3>). Form then searches for the first matching record preceding the current record.

You can intermix FIND NEXT and FIND PREVIOUS functions to search forwards and backwards through the records matched by your query.