How to determine name of active form in VBA 1

[Soundsmith]

How can I retrieve, in VBA code, the name or other ID of the active form (if any, there may also be no open forms)? David 'Dasher' Kempton
The Soundsmith

http://www.thesoundsmith.com

 

[nickjar2]

dim frm as form

frm = nz(screen.activeform)

if frm = "" then
msgbox "no open forms"
else
msgbox frm.Name
end if

I think it is something like this.

Nick

 

[rcalub]

Hi,

What if the there are many forms, and I would like to know all of them?

Thanks.

Rey

 

[rcalub]

Or how do I determine if a certain form is open?

Thanks again.

Rey

 

[nickjar2]

There is a function that comes with one of the default databases, possibly Northwind, called isLoaded. I always import this function into my apps as I find it really useful. You can then use it like:

if isloaded("form&quot then
doSomething
else
doSomethingElse
end if

Hope this is ok,

Nick

 

[rcalub]

Nick,

Thanks alot, your help was very much appreciated!!

Rey