>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

Why did you put "status" in double quotes?

By doing so you used it as a literal "status".

You needed

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