is a form already running?

[Fursten]

Hi,

Can someone tell me if there is a easy way to know if an instance of a form is already running? I want to prevent the users to open the same frame...

Thank you

 

[JohnYingling]

Try this.

Function IsFormActive(strFormName as string) as boolean
Dim frm as form
For Each frm in Forms
    if Ucase$(frm.Name) = Ucase$(strFormName) then
         IsFormActive = true
         exit function
    end if
Next
IsFormActive = false
End Function

http://WWW.VBCompare.Com