>>>>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
>>
>>Sorry, I put the .dbf on the code to see what would happen. It was only a try, and still didn't work. Thanks for the reminder.
>
>What error message you receive?
This form has performed an illegal operation and will be shut down....
He is there and He is not Silent.