>I have some code that keeps on crashing my form and I cannot seem to find our why.
>
>I have it in the LostFocus on a text box on a form.
>
>SELECT man.dbf &&crashes here <<<<<<<<<<<<
> SET order to column1
> IF ! seek(UPPER(alltrim(this.value)))
> MESSAGEBOX("That part is not on Record")
> nodefault
> this.setfocus
> ELSE
> thisform.refresh()
>ENDIf
>
>
>The table exist, is not in use in any other app
>
>I also put a use statement in the form Activate with no luck.
>
>Thanks in advance.
>Brad
SELECT works with aliases (not file names), so when you opened your table it will get alias "man" as default and you should use afterwards:
SELECT man
Edward Pikman
Independent Consultant