Testing Whether a Form is Open

[Frank Wagner]

I wuold like to condition an routine on one form based on
whether another form is open so I can copy data from that
other form. It there a procedure I can use to determine
whether or not that other form is open.

Any help would be appreciated.

Thanks

Frank Wagner

 

[PC Datasheet]

Look in the standard modules if the sample database Northwind Traders for
the IsLaded function and copy it into your database.

 

[Allen Browne]

In Access 2000 and later, you can test if Form1 is loaded like this:
If CurrentProject.AllForms("Form1").IsLoaded Then

For older versions, copy the IsLoaded() function from the Utility module in
the Northwind sample database.