Macro to display error message when no records found

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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.
 
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!
 
Back
Top