test to see if form is open or get the calling form 1

[idono]

How can I test to see if a form is open, other than the current form. Or maybe even find out the name of the calling form.

Any suggestions

 

[kraxmo]

Try the following: (Access 97+)

If SysCmd(acSysCmdGetObjectState, acForm, strFormName) <> 0 Then
   MsgBox &quot;Form is open&quot;
Else
   MsgBox &quot;Form is closed&quot;
End If

where strFormName = your requested form's name Jim Kraxberger
Developing Access solutions since 1995

 

[idono]

For you my friend, have a star. That was easy and just what I needed.

Thanks