Check a form without opening it..

[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.

 

[Neil]

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.

 

[Warrio]

Thanks a lot !
works

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.