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