Macro to display error message when no records found owl37 18.07.2006 10:10:02 Hi all, I want to create a macro which displays an error message when a report is run and no records are found. Any ideas? Thanks a lot.

Solution Found! owl37 18.07.2006 15:55:02 Hi, I have solved this problem. I created the macro MsgBox I opened the report and went into properties and the event tab I used the event 'On no data' and assigned my macro using the dorp down list. Hurahh for me! "owl37" wrote: [Quoted Text] > Hi all, > I want to create a macro which displays an error message when a report is > run and no records are found. > Any ideas? > Thanks a lot. >