Gaylen,
My guess is that VFP creates "filtered cursor". It may happend if condition in WHERE clause is Rushmore optimizable. That would explain why you didn't get an error with another table. The filter expression gets evaluated when record poiner is moved in the cursor. At that point it's running outside of form, so it cannot reference it with THISFORM. If you use local variable it goes out of the scope at this point. To force VFP to create persistent cursor add
NOFILTER CLAUSE to the query.
Select * From deposits;
WHERE policy_no = thisform.lnPolicyNo AND BETWEEN (dep_date,ldbegindate,ldenddate);
Into cursor depositdetail NOFILTER
>I am getting an error message using the following code
>
>
>Select * From deposits;
>WHERE policy_no = thisform.lnPolicyNo AND BETWEEN (dep_date,ldbegindate,ldenddate);
> Into cursor depositdetail
>
>
>
>After the cursor is created and I try to view it in the data session menu option an error message comes up and says 'object is not contained in a form'. Instead of using a form property, I tried using a variable in the where clause and named it "lnPolicyNo" and I get an error message about can't find variable "lnPolicyNo".
>
>Interestingly in the same method I created another cursor from another table and used the same variables in the where clause and did not have a problem with it.
>
>Any ideas on what is happening.
>
>Gaylen
--sb--