sooo

  do case 
             case thisform.ogstatus.value=1
            select  vclient.acc
             if _tally=0
            messagebox('no records')
              else
              Clientstat="A"
endcase

?

>The simplest way would be to select the data into a cursor and check using _TALLY variable if there are records.
>
>
>
>
>>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"
>>&&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