>>>>>>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....
>
>Hmm... It's too much for LostFocus. Would you like to rebuild this textbox from scratch, put code to new LostFocus event and try again?
I deleted the old txtbox and created a new one, placed the code in the lostFocus event and the same thing happened.
He is there and He is not Silent.