I have a complicated report with numerous parameters which will on occasion return no records.
What i want to do is have a new report display when this happens which includes the company logo etc. stating something like "The parameters you have entered have returned no data, please try again."
I don't want to achieve this using a message box or any pop ups at all, due to the way my users are accessing the reports it will have to be a report which gives them the message.
I currently have in the no data property...
- DoCmd.OpenReport "BWRptNO_DATA", acViewPreview
which will open the new report but it does so behind the report with no data in.
Every time i try to insert a Close somewhere in the code....
- DoCmd.OpenReport "BWRptNO_DATA", acViewPreview
-
DoCmd.Close acReport, "BWrptAnalysisOfEnrolmentsByPostCode"
i get an error message saying "This action can't be carried out while processing a form or report event.
Can anyone help me?
