>>>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?
Edward Pikman
Independent Consultant