Detecting No Form Open in CloseEvent

[Lumpierbritches]

Thank you in advance for your assistance.

I would like to know if there's a way to detect if NO form is open, so the
Switchboard is opened and not leaving a user with no interface in the database?

Michael

[Trevor Best]

Lumpierbritches wrote:

Thank you in advance for your assistance.

I would like to know if there's a way to detect if NO form is open, so the
Switchboard is opened and not leaving a user with no interface in the database?

If Forms.Count = 0 Then
' open switchboard
End If
--
Pretentious? Moi?

[user_5701]

Instead of bothering with this, disable the close button on the
switchboard, so they cannot close it, thereby avoiding the situation
you described - the database open with no forms for the user to
use/interact with. You can't really do anything with the database
with no forms open anyway, so either the switchboard should always be
open, or if they close it, the entire application should close.

lu*************@aol.com (Lumpierbritches) wrote in message news:<20***************************@mb-m18.aol.com>...

Thank you in advance for your assistance.

I would like to know if there's a way to detect if NO form is open, so the
Switchboard is opened and not leaving a user with no interface in the database?

Michael