Determine If A Form Is Loaded

[cnealy]

I have an MDI application. At times, I need to make a call to a form only if the form is loaded.

So, for instance, I might have a line of code on frm1 that says:

With frm2.Adodc1
.commandtype = blah
.Recordsource = blah
.refresh
End With

There are two problems:

I only need to perform this refresh if frm2 is loaded. And, when I execute this code, frm1 loses focus, but I don't want that to happen.

Any ideas/suggestions on how to handle this? This is an issue throughout my application.

 

[balves]

Use the Forms collection.

Loop through the Forms collection looking at the .Name property for the form that might be loaded. If you find it, it's loaded.

 

[balves]

Dim frmVar As Form

For Each frmVar In Forms
If frmVar.Name = "your form name" Then
MsgBox "found form"
End If
Next

 

[cnealy]

That worked - THANKS! )