How can I tell if a form is already open

G

Guest

I need to set a variable, and the value of the variable is based on the fact that a specified form is open on closed. I have no idea how to check to see if a form is open, any ideas....

Thanks,
Jerry
 
F

fredg

I need to set a variable, and the value of the variable is based on the fact that a specified form is open on closed. I have no idea how to check to see if a form is open, any ideas....

Thanks,
Jerry
Click to expand...

What version of Access?
Access 2002:
If Not CurrentProject.AllForms("FormA").IsLoaded Then
Do something here
Else
Do something else
End If

Or in all versions, copy this function (from the Northwind.mdb sample
database).

Function IsLoaded(ByVal strFormName As String) As Integer
' Returns True if the specified form is open in Form view or
Datasheet
view.

Const conObjStateClosed = 0
Const conDesignView = 0

If SysCmd(acSysCmdGetObjectState, acForm, strFormName) <>
conObjStateClosed Then
If Forms(strFormName).CurrentView <> conDesignView Then
IsLoaded = True
End If
End If
End Function

Then code:
If Not IsLoaded("FormA") Then
Do this
Else
Do that
End if
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Opening form unexpectedly closes other form 0
filtering a form based on a filter on an open form 2
Is There A Variable Type I can use to Hold a Value Even When theapplication is closed? 5
How to tell if a form is open 3
Open another form if field checked in one form 1
Problem checking if form is open 2
Excel Concatenate Form Name to Parse for function 1
Can I change the color of a form based on status? 6

Top