>>Select somefields from yourtable into cursor curReport where ... >>If _tally>0 >> Report form... >>Else >> Messagebox('No match') >>Endif>>
>>>Do case >>> case thisform.OGstatus.value=1 >>> Clientstat="A" >>> case thisform.OGstatus.value=2 >>> Clientstat="b" >>> case thisform.OGstatus.value=3 >>> Clientstat="c" >>> case thisform.OGstatus.value=4 >>> Clientstat="d" >>>&&A,B,C and D being values in a table >>>endcase >>> >>>Case thisform.ogstatus.value<5 and thisform.ogdesign.value=1 >>>report form report1 for vclient.acc=clientstat preview >>> >>>Case thisform.ogstatus.value<5 and thisform.ogdesign.value=2 >>>report form report1 for vclient.acc=clientstat preview >>> >>>Case thisform.ogstatus.value<5 and thisform.ogdesign.value=3 >>>report form report1 for vclient.acc=clientstat preview >>> >>>Case thisform.ogstatus.value<5 and thisform.ogdesign.value=4 >>>report form report1 for vclient.acc=clientstat preview >>>>>>this works fine. but just that i cant think of a statement in the event there is no A,B C or D in the data base. SO if i select OGStatus and the table has no "A" the report only flashes :( im trying to think of a statment to stop that