capturing the name of the active form in VBA

[Paul]

Is there a way to capture the name of the currently active form in VBA?

Thanks in advance,

Paul

 

[Tom van Stiphout]

On Sat, 6 Feb 2010 18:23:47 -0800, "Paul" <[email protected]>
wrote:

Did you try Screen.ActiveForm.Name?

-Tom.
Microsoft Access MVP

 

[Paul]

I wasn't aware you could do that, and it works great.

Thanks, Tom.

 

[Daniel Pineault]

One method is:

Screen.ActiveForm.Name
--
Hope this helps,

Daniel Pineault
http://www.cardaconsultants.com/
For Access Tips and Examples: http://www.devhut.net
Please rate this post using the vote buttons if it was helpful.

 

[Paul]

Yes, I just found out about that one, Daniel.

Thanks