IsLoaded question

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Tony Williams - 18 Nov 2005 09:57 GMT

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

Reply to this Message

Arvin Meyer [MVP] - 18 Nov 2005 10:13 GMT

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

> 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.
[quoted text clipped - 9 lines]
> Thanks
> Tony

Reply to this Message

Tony Williams - 18 Nov 2005 10:26 GMT

Thanks Arvin import Global Module and it worked OK
Tony

> 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
[quoted text clipped - 21 lines]
>> Thanks
>> Tony

Reply to this Message