So i spent a while removing allllll tables from my reports and adding cursors.
so i have this qry

select Books.*,Acc.prin,Acc.status;
     From;
         Acc;
        inner join mainbase!books;
on acc.ID=books.Id;
where acc.status=("status");
into cursor return

Status is not a field in the table. is is a variable that gets data from an option group

so acc.status has the values A & B

so my program has

public status
do case
      Case thisform.status=1
status="a"
case thisform.status=2
status="b"

So if i go back to my cursor...if i run it that way. the criteria isnt meet so the query doesnt run
but! if i use

(status)

the query works! but! it tells me variable status cannot be found when ever i try to view the cursor code