>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,
I guess this is a redundant use of the "use" command, since I already had it in my main prg. Sorry about the mistake. I should have realized that "use" was already being called from the main program.
I followed Ed's advice and rebuilt the form. It worked on my machine fine.
HOWEVER, I have a mscomm32.ocx activeX control on the form that is crashing on the machine that the application is running on.
Should I copy the X file from my PC to the Application PC, then register it again?
He is there and He is not Silent.