I have a table which is going to be filtered and thus will not show any data all the data is filter out. If that is the case I want to disable the navigation buttons untill there is at least one record for the filtered condition. Is there an efficient way of determining if any records are available after the data is filtered. For example assume the table has an index based on a record code and a site code and site code is A or B and initially only data is for site code A. If I filer on site code 'B' the form is blank since there is no data. But the next and last record navigation buttons are enable even thought there is no place to go to.
What conbination of properties uniquely determines that there are no records? For exmmple would
GOTO TOP
BOF() = .F.
EOF() = .T.
work?