The IsLoaded property of the form in the AllForms collection was new in
Access 2000. Feel free to use it in any recent version.
The code on the MVPs site is older code that is still useful if you need
compatibility with Access 97 or earlier.

Signature
Allen Browne - Microsoft MVP. Perth, Western Australia
Tips for Access users - http://allenbrowne.com/tips.html
Reply to group, rather than allenbrowne at mvps dot org.
> I have been using the following in my databases to determine if a form was
> open or not
[quoted text clipped - 20 lines]
>
> Daniel
Dirk Goldgar - 06 Dec 2006 21:16 GMT
> The IsLoaded property of the form in the AllForms collection was new
> in Access 2000. Feel free to use it in any recent version.
>
> The code on the MVPs site is older code that is still useful if you
> need compatibility with Access 97 or earlier.
Interestingly, the older, SysCmd version function is actually faster,
not that it matters in any practical application. The nice, explicit
property exposed in the newer version is preferable for
self-documentation purposes. I tend to use the oder version, though,
for maximum compatibility in an application I'm developing for multiple
clients.

Signature
Dirk Goldgar, MS Access MVP
www.datagnostics.com
(please reply to the newsgroup)