I had a situation with a method which executes the following code

SELECT rpt.*,inv.u_of_meas ;
  FROM crsReport rpt ;
    LEFT JOIN inventor inv ON rpt.uniq_key = inv.uniq_key;
  INTO CURSOR crsReport READWRITE

REPORT FORM reports\pick_by_seq TO PRINTER PROMPT PREVIEW NOCONSOLE

I was getting a "Variable Not Found" error.

I checked and the current ALIAS() was crsSchedule.
So I put in an explicit
SELECT crsReport
immediately after the Select statement.

"Variable Not Found".............

I was aware of situations where the Report Writer is not happy when focus is on a grid so I made the first line of the method

thisform.txtBuild.setFocus

This solved the problem until yesterday. I had re-compiled the app and the problem re-surfaced. Immediately after the SELECT SQL statement the active cursor was no longer the one specified by the INTO CURSOR claus.

I changed the SETFOCUS() at the beginning of the method from the TextBox to a Command Button and all was well again.

Does anybody have an explanation of why the INTO CURSOR does not become the active work area?

Absent an explanation of why.......is there something that lists the conditions which could cause this situation?

Thanks to all.............Rich