Avoiding reloading of forms again and again

[usertest]

Hello,
I have a dashboard that has multiple forms (4-5) that load when the dashboard is clicked.
So when I open the form 1, it closes the dashboard and opens a new form in a new tab.
Now when I exit the form 1, the logic behind is to again open the dashboard. But each time I navigate back to the dashboard, all the loading of 4-5 forms happen again.
How can i avoid reloading the dashboard again and again.

I believe we can set a global variable that can maintain the state. But don't exactly know how to code that.

Does anyone know how to proceed on that and can share any code snippets?



Thanks!

[Micron]

By "tab" I'm going to assume your forms are loaded in tab view - not that they are forms on navigation form tabs.
Hide the dashboard form, don't close it. Unhide when form1 closes.

EDIT - right after posting that, I concluded that it probably doesn't matter about the tabs.

[davegri]

If the switchboard and 4-5 forms are truly independent freestanding forms, code to load a form that is already loaded will be ignored by Access. Prove it by adding a temporary messagebox in the form load event.

[Micron]

code to load a form that is already loaded will be ignored by Access

Except that the forms are not open?

I have a dashboard that has multiple forms (4-5) that load when the dashboard is clicked.
So when I open the form 1, it closes the dashboard

[davegri]

@Micron - how can a form not be open when it is loaded? Perhaps you missed my condition that the forms be independent and freestanding (not subforms or contained within a tab on a main form).
The intent of the messagebox was to indicate that the form would display the messagebox if the form actually loaded, but would not display if a repeat load was attempted.

[Minty]

Rather than close the dashboard, hide it?
Then unhide it when returning to it.

[Micron]

how can a form not be open when it is loaded?

I don't think I said that, which is why I quoted the OP. If the forms are on tabs on some dashboard form, then when that form is closed they are no longer open, right? So my comment about tabs not mattering really isn't correct. It does matter if we're going to have different notions of what the design is. It would help if OP clarifies things.

[Micron]

Rather than close the dashboard, hide it?
Then unhide it when returning to it.

As stated in post 2?

[Minty]

As stated in post 2?

Pass me the white stick please.

[usertest]

So when I open the dashboard, I have multiple forms and each form has a button to "assign/allocate" and once you click on that assign button, it closes the dashboard and open a new form.
Now, there is a button on the new form called "exit".
Once you click on the exit button, it reloads the dashboard again.

So each time the dashboard loads, all the 4-5 forms are loaded back again which basically is running SQL queries on the backend.

How can i avoid reloading the forms on the dashboard again and again whenever the user clicks on "exit" button

I don't think I said that, which is why I quoted the OP. If the forms are on tabs on some dashboard form, then when that form is closed they are no longer open, right? So my comment about tabs not mattering really isn't correct. It does matter if we're going to have different notions of what the design is. It would help if OP clarifies things.

[Micron]

How can i avoid reloading the forms on the dashboard again and again

That has been answered twice already. Don't close - hide and unhide.