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