hi,
thank you for reply,it works

i try to get data from my table AFM, via select somthing put all records at
table am2,select again from afm put all records at am3,
every time i run my form ,becuse i get this data form outside my dirctory

for that i need to delete the 3 tables afm,am2 and am3 every time.

thanks

>>hi all,
>>
>>any idea ,help
>>
>>i need to drop 2 tables am2,am3 from my database(mydbc1),
>>every time i run my form.
>>

>>drop e:\depstudy\mydbc1\am2
>>drop e:\depstudy\mydbc1\am3
>>

>>
>>thanks
>
>

>OPEN DATABASE e:\depstudy\mydbc1\mydbc1
>if indbc('am2','Table')
>  DROP TABLE am2
>endif
>if indbc('am3','Table')
>  DROP TABLE am3
>endif
>

If you would drop them every time you run a form why are you adding them to a database in the first place.
>Cetin