I'm looking for VBA code to check if a report is already open prior to trying to open it. I've noticed that if a report is already open and the code tries to open it again, that the already open report gets the focus and appears on top of the windows. However, a user may have changed criteria and not realize that a report needs to apparantly be closed before it is opened. Hence, they may not realize that the report they see if for a different set of conditions. So, I guess I need code to check if the report is open and then close it, prior to reopening.
Can the report be refreshed instead of closing and then reopening?