you mean dont use tables in the DE of my ReportS?
>You should always let a cursor drive a report, and not a table directly.
>Select somefields from yourtable into cursor curReport where ...
>If _tally>0
> Report form...
>Else
> Messagebox('No match')
>Endif
>
>>Hello!
>>i have this form with two option groups so i use the two of them to help me formula a report
>>name OG status and OG design both hav four option groups
>>
>>so my code is somethin like this
>>
>>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"
>>
>>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