Hi Jim,
This seems a little too obvious to me, so maybe I'm missing something, but in your SQL statement, you're not pulling in the Location field, only the BRAND_NO, COLOR, SEX, DATE_FOAL, SIRE1, DAM1, MARKINGS ... is this the problem?
~Bonnie
>Mark,
>
>Thanks for the quick response, but unfortunately I did not explain my situation fully.
>
>The error shows up with all the fields on the report form, and the reference on the report form is to the field name in the table, not the value of the 'textbox' on the form.
>
>It's got to do with the cursor's fields not being "seen" by the report form.
>
>Thanks,
>
>Jim
>
>
>
>>cLocation = trim(ThisForm.Hstxtfield.VALUE)
>>SELECT BRAND_NO, COLOR, SEX, DATE_FOAL, SIRE1, DAM1, MARKINGS ;
>>FROM MASTER WHERE LOCATION = ?cLocation ;
>>
>>
>>>Hi All,
>>>
>>>I'm trying to create a temporary cursor which I then want to use to send a report to the printer.
>>>
>>>Here is a SQL statement, in the click event of a command button on a standard type form. There is no data environment as I "use" my free tables in the Load Event.
>>>
>>>SELECT BRAND_NO, COLOR, SEX, DATE_FOAL, SIRE1, DAM1, MARKINGS ;
>>>FROM MASTER WHERE LOCATION = ThisForm.Hstxtfield.VALUE ;
>>>into cursor mastertemp
>>>repo form hsrplocation to print prompt preview
>>>ThisForm.Hstxtfield.value = " "
>>>ThisForm.Hstxtfield.setfocus()
>>>thisform.refresh
>>>
>>>I am getting this error message when it runs the 'repo' command.
>>>(Variable "Location" is not found.)
>>>
>>>I've tried this is in the 'expression' box of the field on the report form.
>>>1. mastertemp.location
>>>2. location
>>>
>>>Does anybody know what I'm doing wrong?
>>>
>>>Thanks,
>>>
>>>Jim Harvey
>>>
jharvey@netrax.net