This is a known behavior in Access: reports open asynchronously and don’t block code execution, even if you set them as modal. Unlike forms and MsgBoxs, reports don’t have a built-in modal mode that pauses VBA execution.
To handle this, you typically need a workaround such as:
Using a timer or...