Thank you, Craig.

I found that the problem was that in the Activate method of the form from which the report is called has a code to "SELECT (SomeOtherAlias)". And, I guess, right before the report is displayed this method fires. I am surprised as I thought that the form will be in focus after the report is closed. Anyway, since I know what causes the problem, I will find a way to deal with it.

UPDATE: I found that the problem with focus and Activate method was caused by my BROWSE command that I was using right before calling the report to verify that the "right" cursor was selected.

>There could be a cursor created in the report or a report field has reference to the other cursor. The easiest way to track this down is to create the cursor, then open the report in the report designer then preview the report. The error will popup and point right to the report field.
>
>>Hi,
>>
>>I am getting a strange error when running a report. The error say (as in the title of this message) 'variable "myfield" is not found.' I check the cursor right before running the report and the column "myfield" is there. I don't know if it matters but this column is a JOIN table column. Nevertheless the column is found and is in the cursor.
>>
>>Any suggestions to what might be causing this error?
>>
>>UPDATE: I found that it seems like report pulls the data not from the cursor selected right before report but from another cursor. How can it be?