I now see that I forgot the field list, which is required for the SELECT - SQL command. Use an asterisk, to include all fields.
select * from mstr where UPPER(inname) = UPPER(TRIM;
(thisform.pageframe1.page1.text1.Value));
and nam1 =thisform.pageframe1.page1.text4.Value and;
datein>=thisform.pageframe1.page1.text3.value .and.;
datein<=thisform.pageframe1.page1.text5.value;
into cursor TempReport;
nofilter
if _tally = 0
MessageBox("No records selected. Try changing your criteria.")
else
report form mstr22 preview
endif
select mstr
Difference in opinions hath cost many millions of lives: for instance, whether flesh be bread, or bread be flesh; whether whistling be a vice or a virtue; whether it be better to kiss a post, or throw it into the fire... (from Gulliver's Travels)
