on nodata, show message then close report (1 Viewer)

[deekras]

on nodata, i want to show a message and then close report, sending it back to record selection dialog form.

i have the message, i just can't get it close the report and send me back to the form.

any suggestions?

 

[Rich]

Check out "solutions" sample database supplied by Microsoft, Employee sales.

 

[BarkerD]

Put this function call in the Report's No Data Event

=ThereIsNoData()

Function ThereIsNoData()

MsgBox$("There is no information for the criteria that you specified." & Chr(10) & "Please choose the Menu item and try again.")
DoCmd.CancelEvent

End Function