Set up IsLoaded function

[Lynn73]

Hi
As part of my macro I need to define the IsLoaded function - I have tried searching through the Access help pages but IsLoaded doesn't seem to be listed on any of them.

Can anyone help??
Thanks

 

[boblarson]

CurrentProject.AllForms("FormNameHere").IsLoaded

 

[Lynn73]

Hi
Sorry but where exactly do I need to put this text? Is it in the actual macro or do I need to define it elsewhere so I can use it in other macros later on?

Thanks again

 

[boblarson]

It is actually VBA as I didn't see that this was the Macros category. But, if you put this into a Standard module (not a form module):

Public Function IsFormLoaded(strFormName As String) As Boolean
    IsFormLoaded = CurrentProject.AllForms(strFormName).IsLoaded
End Function

You can then call the function from your macro like this

Macro Action: RunCode
Arguments: IsFormLoaded("TheNameOfYourFormHere")

But, It's been so long since I've used macros that I can't remember exactly how you would incorporate that.