How to by pass CLOSE event?
My report deletes a toolbar whenever the report is closed however, I have an option to re-query the report date in order to “refresh” it with new criteria. For this refresh option I am trying to go into the reports design view & then changing its record source by re-opening with a specified WHERE condition. But whenever I use this refresh option, it is crashing because (I am assuming here) the report closes (ie deleting the toolbar that activates a requery) and then tries to re-open but cannot locate the toolbar. Any advice on my situation? Please advise.
My report deletes a toolbar whenever the report is closed however, I have an option to re-query the report date in order to “refresh” it with new criteria. For this refresh option I am trying to go into the reports design view & then changing its record source by re-opening with a specified WHERE condition. But whenever I use this refresh option, it is crashing because (I am assuming here) the report closes (ie deleting the toolbar that activates a requery) and then tries to re-open but cannot locate the toolbar. Any advice on my situation? Please advise.
