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?

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

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