Report: No Data issue.

[Kodo]

I have a list box in which my users can select multiple names from. Then they print a word document that is populated with their selections profile information. It also runs a query for a report on this person. My issue is that if the report has no data, I don't it to print out, but I want it to continue to print the remaining documents for the other users selected.

Docmd.cancel even on No_Data will stop the action completely and hoses the operation.

Any suggestions on how I can gracefully terminate the printing of reports that have no data but continue to print the rest of the documents that do?

 

[GUIDO22]

Is it possible to check each selection in the list as it is made by the user i.e. when user selects list item - run data check to see if any reporting info exists for that person. If not, report to the user and de-select the item.
Thus - when report is run only those items with data will print out?

 

[Kodo]

Thanks for your reply, I decided to hide all the controls and disply a "No Data Available" message on the form if no data fired. This way they recieve some notificiation that there is no report data and not think that a report didn't print because there was some problem with the code..