>>Hi Nick,
>>
>> So were you able to try the program out? What did you find out?
>Hello Napoleon,
>
>I am looking at your formset right now, and so far nothing disappears from the dataenvironment, You have there BOOKS, AUTHORS and PARAMCAT tables, right?
>Your Find form cannot find ALLBOOKS view - it is not in DE.
>(locate all for alltrim(allbooks.accessno)== alltrim(thisformset.form2.text1.value))
I just added ALLBOOKS view to DE, now it works and stays there. BTW why do you set AutoCloseTables to .F. ?
Nick Neklioudov
Universal Thread Consultant
3 times Microsoft MVP - Visual FoxPro
"I have not failed. I've just found 10,000 ways that don't work." - Thomas Edison