Brad --- Let me restate the question: When and how is the table being opened? At some point you have a USE table or have the table in the Dataenvironment.
>>Hi Brad ---
>>
>>When are you USE-ing the table?
>>
>>
>>>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
>
>
>John,
>
>I only assummed that putting the use statement might help. I am using the table when the form is active.
------------------------------------------------
John Koziol, ex-MVP, ex-MS, ex-FoxTeam. Just call me "X"
"When the going gets weird, the weird turn pro" - Hunter Thompson (Gonzo) RIP 2/19/05