IsLoaded question

[Tony Williams]

I have the following code to determine if a form is loaded when another form
is opened and if so the first form should be closed.
Private Sub Form_Load()
If IsLoaded("frmfindrecord") Then
DoCmd.Close acForm, "frmfindrecord"
End If
End Sub

However I get a message that says Compile Error-Sub or function not defined.

Can anyone tell me what's wrong here?
Thanks
Tony

 

[Arvin Meyer [MVP]]

In the latest version of Access, IsLoaded is a property of a form, but in
earlier versions, it is a function which must be defined. You'll find one
version of it in the Northwind sample database's standard modules.
--
Arvin Meyer, MCP, MVP
Microsoft Access
Free Access downloads
http://www.datastrat.com
http://www.mvps.org/access

 

[Tony Williams]

Thanks Arvin import Global Module and it worked OK
Tony