If you SET NEAR OFF record pointer will be at EOF on unsucessfull SEEK.

>I had to do a SEEK() function to find the particular sub-data and display it on the form, but when the data isn't found, it still displays the supporting data, which it should not do. I have that supporting data in non-editable textboxes. I want to force the supporting file to EOF() when it doesn't find the related record.
>
>Now, we could get into the other point about why I am going to all this trouble when all I'd have to do "normally" is relate the two tables and display the 2nd table's data on the form. However, the data sits on a pageframe and it does not seem to refresh at all when I go from one record to the next, even though relations were set properly. So, I am jerry-rigging this to force the data to appear by SEEK()ing into the secondary table and then displaying its data with a refresh for those particular textboxes, but I still see data when there is no supporting record (it should not display).
>
>Okay, I just ate a huge amount of chocolate and vanilla ice cream, the first time in a year, so I'm full of sugar now and may not be at my best in writing skills today. :)