Macro fails on closing form

[Lou_Reed]

The thread relates to another thread on the forum, but I think that it is independent enough to warrant its own thread. In the db that
is attached as a zip file when one opens fromProjectManagement everything is fine. Now when you try and close the form using the Close
Form button not so much. This crashes and give an error in the VBA code, not even in the macro.

The macro could not be simpler sinceit was created by the Macro wizard and all it does is close a form. Wht is cassuign this error and how
do I fix it.

Respectfully,

Lou Reed

[ranman256]

since I cant see the code, I would assume there is a pending operation preventing the close.
Close is pretty simple.

[Lou_Reed]

I included a zip file of the db. All one has t do is unzip it run it and see what I am talking about.

Respectfully,

Lou Reed

[John_G]

Lou, please remember that not everyone will download database files, for security reasons. Your flippant response to Ranman256 was uncalled for.

That said, I did download your DB; the form opens and closes fine when opened from the switchboard. The error occurs when you open the form on its own - when closing, it references the switchboard form which is not open, causing the error.

[Lou_Reed]

I in no way meant to be flippant. I am just unsure why that form fails to close with a program crash (there is also a second form that fails to close in a similar way) and everything else closes fine.
Please understand, I included the form for the reason that "seeing is believing". There was absolutely no intention of disrespect or flippancy.
I was just trying to help someone who wanted to solve the problem. If you have the code then there is no need to guess or speculate.
The cod is right there. everything that you need to know is included.

I am very grateful for the help I received here. I certainly meant no harm; if it came off that way then I am truly sorry.

Sometimes I type too quickly without thinking. Do not confuse my haste for rudeness.

Respectfully,

Lou Reed

[Lou_Reed]

John_G:

I see your point. I almost never use the switchboard when I am creating forms, tables and VBA code. I open the specific form either in design mode or form mode and work from theree. That does not mean that in there are no elaborate form operations.
There are.
Now how do I get the frmProjectManagement and frmConfigure to operate only when they and they alone are opened and closed?

Any help appreciated. Thanks in advance.

Respectfully,

Lou Reed

[John_G]

Both those forms have one line in the On_Close event : Forms!DivisionDashboard.Update_Actions

and it is that line that causes the error through the reference to the DivisionDashboard form. Just delete the whole On_Close Sub (all three lines of it!) in each form and they should close without error.