>>>>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???
>if _tally = 0 > =messagebox('Sorry, no records match your criteria...',0,'No Records') >else > report form ... >endif >Thanks A Lot I will send you a private message in the next few days and we can figure all else then and I would be happy to work with you!