Thanks Vishal, I found the place I can change the Error message however that belongs to a report - not a Form -- I am calling the page that is a FORM in nature and not report - that has a messages etc.
Also by trigger, I was referring the semantics of "triggering" not the reserved word.. THanks,
How are you calling the form? From a report? a page just passing an ID? Would help to know, so an answer can be provided..
if the report is calling form passing a PK.. You could do a pre-header process that takes the passed in PK and determines if there is no row to be selected.. If there is no data found you could redirect the user to a separate page..