I have a button on a form that launches a report. This report is based on a query that asks the user to enter the invoice number. I have used the code below, but I want to get it to do the following:
If the user enters a number and there is no data attached I do NOT want the report to print out (with 'error' all over it). I want it to cancel the event and display a message box stating that there is no data available. I have tried several things out but with no luck. Any ideas?