[Okta Webinar] Learn how to a build a cloud-first strategyRegister Now

  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 208
  • Last Modified:

Why is one tab staying open when the macro should be closing it?

I have one tab (see image) that stays open even after you press and of the following buttons that should open the tab and close all others?

The attahed image has the two steps to re-create the error.
1 Solution
Scott McDaniel (Microsoft Access MVP - EE MVE )Infotrakker SoftwareCommented:
You can't close a form where code is running (even a macro). If you want to close all forms, you'd have to do that from another form. The Main form could perhaps close the other forms - maybe in the GotFocus or Activate event.

Featured Post

Visualize your virtual and backup environments

Create well-organized and polished visualizations of your virtual and backup environments when planning VMware vSphere, Microsoft Hyper-V or Veeam deployments. It helps you to gain better visibility and valuable business insights.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now