J jrmellis Registered User. Local time Today, 00:18 Joined Mar 21, 2002 Messages 30 May 14, 2003 #1 How do I use VB to check if a form is open? Thanks
Mile-O Back once again... Local time Today, 00:18 Joined Dec 10, 2002 Messages 11,316 May 14, 2003 #2 There's a function in a module in the Northwind database called IsLoaded(). Copy that into your database. In code you can then use it like this: To determine if a form is open: Code: If IsLoaded("frmYourForm") = True Then or, more simply: Code: If IsLoaded("frmYourForm") Then To determine if a form is closed: Code: If IsLoaded("frmYourForm") = False Then or, more simply: Code: If Not IsLoaded("frmYourForm") Then
There's a function in a module in the Northwind database called IsLoaded(). Copy that into your database. In code you can then use it like this: To determine if a form is open: Code: If IsLoaded("frmYourForm") = True Then or, more simply: Code: If IsLoaded("frmYourForm") Then To determine if a form is closed: Code: If IsLoaded("frmYourForm") = False Then or, more simply: Code: If Not IsLoaded("frmYourForm") Then
J jrmellis Registered User. Local time Today, 00:18 Joined Mar 21, 2002 Messages 30 May 14, 2003 #3 Thanks. Would IsLoaded return true if the form is hidden?
Mile-O Back once again... Local time Today, 00:18 Joined Dec 10, 2002 Messages 11,316 May 15, 2003 #4 Yes, it would.