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
Mark McCasland
Midlothian, TX USA