Exactly. I always try to avoid using the DE. If you find using the DE easier, you can create a table with the same name as the cursor, and use that table when you design your reports (or forms). Remember to delete the table(s) after you are done with the design.
>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