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