Macro Condition IsLoaded()

[Guest]

I have a database 4 people use. There is a macro to run some delete and
append queries. I want to use the IsLoaded() condition to stop the macro if
the form is open by one of the users. This does not seem to work. The last
thing the macro does is open the form which I use the (...) in the condition.
Any ideas?

 

[Guest]

Hi

You may be better to use a little bit of code like

If CurrentProject.AllForms("FormName").IsLoaded = True Then etc etc

something like


If CurrentProject.AllForms("FormName").IsLoaded = True Then
Some message box
Else
Something else
End If