>>SELECT strain, quantity, location2, userid, date, notes ; >> FROM cuttings ; > where strain = 'blueberry' ; >> ORDER BY date ASC, strain ASC ; >> INTO CURSOR cuttingsreport >>SELECT cuttingsreport >>REPORT FORM cuttings1.frx TO PRINTER PROMPT PREVIEW >>CLOSE DATABASES ALL >>>>
>SELECT strain, quantity, location2, userid, date, notes ; > FROM cuttings ; > WHERE strain = 'blueberry' ; > ORDER BY date ASC, strain ASC ; > INTO CURSOR cuttingsreport >SELECT cuttingsreport >REPORT FORM cuttings1.frx TO PRINTER PROMPT PREVIEW >CLOSE DATABASES ALL >So I inserted this code and now it shows for a split second a report but then closes. I removed close databases all and that had no bearing? only 1 line has been added, is their another statement which should be added or???