Do you have a filter on fcab?
Try this...
SELECT * FROM fcab INTO CURSOR tbgrid NOFILTER
and in the click()
SELECT fcab
GO 858
IF NOT DELETED()
[some code]
ENDIF
Don't LOCATE for recno(), because it cannot optimize. Don't add an index on recno() cause it will cause you problems when/if you buffer the table.
>hi thomas,
>
>no, record is not deleted. but i have
set deleted on on my form.
>
>here, i have a grid in my form. recordsource is
select * from fcab into cursor tbgrid.
>
>i have this code in my command click(),
>
>
>sele fcab
>go top
>locate for recno()=858
>if found()
>[some code]
>endif
>
>
>when i run this form, found returs to .f..
>
>i also find this out,
go top does not point the record pointer to 1.
>
>when i sele tbgrid, found returns to .t.
>
>what could be wrong? pls help.