Detect State of a Form

[mishbaker]

What command/code could I use to detect the state of a form? For instance, if it is open or not.

I'm pretty sure there has to be a command for this already and I'm just missing it in the help file. Currently I have the form setting a global boolean onload and onunload. If the form is open it is requeried/refreshed when a new employee is selected on a different forms combo box. Otherwise is ignores the requery/refresh request.

I just know there has to be an better way.

Thanks in advance guys

All lessons learned from the School of Hard Knocks........at least tuition is cheap.

 

[PHV]

Take a look at IsLoaded:
If CurrentProject.AllForms("your form name").IsLoaded

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