Prev: Saving records for later recall
Next: Turning on and off Data Entry
From: Paul on 6 Feb 2010 21:23
Is there a way to capture the name of the currently active form in VBA?

Thanks in advance,

Paul


From: Tom van Stiphout on 6 Feb 2010 21:46
On Sat, 6 Feb 2010 18:23:47 -0800, "Paul" <BegoneSpam(a)forever.com>
wrote:

Did you try Screen.ActiveForm.Name?

-Tom.
Microsoft Access MVP


>Is there a way to capture the name of the currently active form in VBA?
>
>Thanks in advance,
>
>Paul
>
From: Paul on 6 Feb 2010 22:01
I wasn't aware you could do that, and it works great.

Thanks, Tom.


From: Daniel Pineault on 6 Feb 2010 22:19
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" wrote:

> Is there a way to capture the name of the currently active form in VBA?
>
> Thanks in advance,
>
> Paul
>
>
> .
>
From: Paul on 7 Feb 2010 03:38
Yes, I just found out about that one, Daniel.

Thanks


 | 
Pages: 1
Prev: Saving records for later recall
Next: Turning on and off Data Entry