Is there a Is Open propert for forms?

[CompAnalyst]

Ok stupid question-

I am trying to do something which is essentially

If form is open, then
do this.

And i can't seem to figure out how to determine with VBA coding if the form is open or not. ARGH... help!!!????


Rachel, Compensation Analyst

 

[Remou]

I think you need IsLoaded:
[tt]CurrentProject.AllForms("frmForm").IsLoaded[/tt]

 

[PHV]

If CurrentProject.AllForms("form name").IsLoaded Then

Hope This Helps, PH.
Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884 or FAQ181-2886

 

[Zion7]

...and there's this,

If SysCmd(acSysCmdGetObjectState, acForm, "frmSales") = acObjStateOpen Then