Open Form

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

JimP - 23 May 2007 13:45 GMT

What code would I use to determine if "MyForm" is open?

Reply to this Message

Graham R Seach - 23 May 2007 14:09 GMT

Jim,

Try using this function.

Public Function IsLoaded(sFormName As String) As Boolean
IsLoaded = ((SysCmd(acSysCmdGetObjectState, acForm, sFormName) <> 0) _
AND (Forms(sFormName).CurrentView <> 0))
End Function

Regards,
Graham R Seach
Microsoft Access MVP
Sydney, Australia

> What code would I use to determine if "MyForm" is open?

Reply to this Message

Klatuu - 23 May 2007 14:11 GMT

CurrentProject.Allforms("MyForm").IsLoaded

Signature

Dave Hargis, Microsoft Access MVP

> What code would I use to determine if "MyForm" is open?

Reply to this Message