When my report opens my pop-up form (which is not modal) appears on
top of the report.
I use the on No Data event to show a message to the user if no records
are to be displayed and then when OK is pressed they are returned to
the pop-up form to try again.
I don't seem to be able to use On Open event for the report to do
anything as the On No Data then kicks in as the report has already
opened. When I try alternatives such as making the form active and
changing its visible property to false so only the report appears, it
falls down if the report has no data and me.visible becomes the
current form which hides it. I can get some kind of success, but the
pop-up box keeps closing after the message appears notifying of no
records.
So, this is what i want:
When I press the button on my pop-up form I want the report to open in
front of it. So When I close the report the pop-up form is still
there. When the message box showing the user that no records are
there, I again want the pop-up form to remain when the message box is
closed down.
Cheers for any help.