Check a form without opening it..

  • Thread starter Thread starter Warrio
  • Start date Start date
W

Warrio

Hello!

How is it possible to check if a form is open without loading it
automaticly?..
because if I try to run the code below, the form is loaded automaticaly and
apears on the top of the actual form..

If Form2.Visible Then

Endif

Thanks for any suggestion.
 
Hello,

You do not say what version of Access you are using. For Access 2000 and
later (i think) you can use the following:

If CurrentProject.AllForms("YourFormName").IsLoaded Then
' Form is open
End If

Before Access 2000 i think there is a general function called IsLoaded in
the Northwind sample database which you can copy and use in your project.

HTH,

Neil.
 
Thanks a lot !
works


Neil said:
Hello,

You do not say what version of Access you are using. For Access 2000 and
later (i think) you can use the following:

If CurrentProject.AllForms("YourFormName").IsLoaded Then
' Form is open
End If

Before Access 2000 i think there is a general function called IsLoaded in
the Northwind sample database which you can copy and use in your project.

HTH,

Neil.
Click to expand...
 
Back
Top