Search results

i have a form which has 9 combo boxes. each combo box value when selected inturn runs a parameter query. i need to write a code wherein if zero (0) rows are returned it should not show me an empty sheet, else show a message saying, no rows found for this. any suggestions,...please help! shivaleee

i have this query: SELECT agr_1251.AGR_NAME FROM agr_1251 WHERE (((agr_1251.OBJECT)="s_tcode") AND ((agr_1251.FIELD)="tcd") AND ((agr_1251.LOW)="f110")) OR (((agr_1251.OBJECT)="f_regu_buk") AND ((agr_1251.FIELD)="fbtch") AND ((agr_1251.LOW)="2" And (agr_1251.LOW)="3" And (agr_1251.LOW)="11"...