Is form Open?

  • Thread starter Thread starter Lyle
  • Start date Start date
L

Lyle

I need to have one form check to see if another form is open. Anyone know
how to do this??
Thanks,
Lyle
 
Hi Lyle

You can use the following function to check if the a form is loaded.

Best Regards

Maurice St-Cyr
Micro Systems Consultants, Inc.


Function FormIsLoaded(MyFormName As String) As Boolean
'
' Determines if a form is loaded.
'
Dim i As Integer
FormIsLoaded = False
For i = 0 To Forms.Count - 1
If Forms(i).FormName = MyFormName Then
FormIsLoaded = True
Exit Function ' Quit function once form has been found.
End If
Next i
End Function
 
You must log in or register to reply here.

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
Separate Form 0
filtering a form based on a filter on an open form 2
Converting data 2
filtering a form based on the values of a subform 0
Help with form load 5
Access Form Refresh 1
Update Two Tables Using One Form Contents 0

Back
Top