>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