KP_SoCal

<div>
Precisely what I needed! Thanks so much!!!
</div>


Precisely what I needed! Thanks so much!!!

<div>
<div class="content wysiwyg-content">
I'm running MS Access 2016, and I'm looking for a function that will do the following when closing a form in my database.<br />
<br />
1. After active form closes, check if there are any other open forms<br />
2. If there are no other open forms, fire a command such as 
<pre><code id="code-10-29164381-1">MsgBox &quot;All forms have been closed.&quot;</code></pre>
<br />
I appreciate any expert advice you can provide! =)
</div>
</div>


I'm running MS Access 2016, and I'm looking for a function that will do the following when closing a form in my database.

1. After active form closes, check if there are any other open forms
2. If there are no other open forms, fire a command such as (CODE)

I appreciate any expert advice you can provide! =)

MS Access...check for any open forms

Databases are organized collections of data, most commonly accessed through management systems including schemas, tables, queries and processes that allow users to enter and manipulate the information or utilize it in other fashions, such as with web applications or for reporting purposes.

Databases

Microsoft Access is a rapid application development (RAD) relational database tool. Access can be used for both desktop and web-based applications, and uses VBA (Visual Basic for Applications) as its coding language.