Skip Record in report if error is found

[bjreb]

Looking for a way to skip a record in a report based on a query. I am running a photo database with the images linked to an imagebox. If the photo link is not valid I have a "sorry no photo" JPRG to show. Is there a way to skip the records with bad links so the Sorry JPEG won't show up.

To simplify. On error skip record

Thanks
Andy

 

[chadt]

If this is in the detail section of the report...try using the Onformat or OnPrint event of the Reports detail section

Need a sample...email me