Diane,

Do you really want the user to see an empty report? Or just to have them notified that there ARE no records? I always use a cursor containing just the records for the report (instead of a filtered table) and I can check _tally after the SELECT runs. If _tally = 0, then I put up a messagebox stating that no records were found. If _tally > 0 then the report runs.

If for some reason you REALLY want an empty report visible (clients sometimes demand strange things....), you'll probably have to add an empty record to your report cursor. This will mean you have to make it a read/write cursor before appending a record.

HTH
Barbara

>Hello all,
>
> My question is how to get into the report when there is no record to be returned. When I preview the report, it flashs very fast then closes without any performance.
> Is there any way that I can display a message which notices that there is no record there, or keep the report open even all fields are blank?
> Any susgession would be appreciated!
> Diane.