Hi Johnnas,
Whe you use the SET FILTER command you can use the EOF() function to check if there are any records in the filter.
SET FILTER TO Lastname = "Don't find anything"
GO TOP
IF EOF()
? "No data in filter"
ENDIF
>Hello there!
> I would like to ask for some suggestions from you guys. The problem is on how to determine
>if a table has no records to display after a filter. I know somebody knows how to do it.
>
>Thanks,
>
>johnnas
Benn Kjaer
MS Certified Professional - Visual Foxpro
"There is something rotten in the state of Denmark"
"Why make user-friendly programs, when there aren’t any friendly users :o)"