How to test if a form is open

[Joey]

Hello all,

How does one test to see if a form is open? Is there an IsNull function
but for forms (like IsOpen(formName))? Or is there some object property
or collection where I must seek?

Thanks,
Joey.

 

[Albert D. Kallal]

You can ues:

 

[Albert D. Kallal]

Sorry...you can use:

http://www.mvps.org/access/forms/frm0002.htm

 

[Van T. Dinh]

If you use A2K or later:

CurrentProject.AllForms("FormName").IsLoaded

returns True (Form is opened/loaded) or False (Form is not opened/loaded)