Nancy,
I think while SQL commands are executing thisform can sometimes no longer in scope as far as VFP is concerned. I've had to make sure that object properties are not used for view parameters, they need to be copied to local memvars before issuing a Requery().
>> update customers set company = thisform.text2.value ;
>> where custno = thisform.text1.value
>
>That's really weird. It seems to be fine with something like "thisform.SomeProperty". I feel like this is a bug. Anybody else?