D deekras Registered User. Local time Today, 21:07 Joined Jun 14, 2000 Messages 169 Feb 11, 2001 #1 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?
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?
R Rich Guest Feb 11, 2001 #2 Check out "solutions" sample database supplied by Microsoft, Employee sales.
B BarkerD Registered User. Local time Today, 21:07 Joined Dec 1, 1999 Messages 106 Feb 14, 2001 #3 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
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
