How to determine the end of the report

[dsmaj]

I've got a report with a bunch of code in the Detail_Print section which calls on values of certain bound text-boxes on the report in order to determine whether to set certain labels to visible or not. Everything works fine, unless the query doesn't return any rows, in which case I get a run-time error informing me that the code that refers to the txtBox controls does not evaluate to anything. Is there anyway I can check for EOR (End Of Record ?) in order to conditionally run that code. If that's not the problem, does anyone have any idea what it might be?

Thanks in advance,
Sam

 

[Rich]

Use the NoData event of the Report to Cancel the opening of the Report

 

[dsmaj]

Perfect

Thanks rich...that works perfectly.

Sam