Google Groups no longer supports new Usenet posts or subscriptions. Historical content remains viewable.
Dismiss

Got Focus and Activate events not working

522 views
Skip to first unread message

MAJICMnt

unread,
Dec 11, 2007, 4:18:03 PM12/11/07
to
I have a pop-up form that has a macro attached to the got focus and activate
events. The form, however is not calling upon those events. I added a
messagebox to the macro and it never opens. What could be a reason for this?

Klatuu

unread,
Dec 11, 2007, 4:32:01 PM12/11/07
to
If you are talking about the form's got focus event, it will not fire if
there is any control on the form that can take the focus.

As to the Activate event, it should fire, but try moving it to the Load event.
--
Dave Hargis, Microsoft Access MVP

Dirk Goldgar

unread,
Dec 11, 2007, 5:18:22 PM12/11/07
to
"MAJICMnt" <MAJI...@discussions.microsoft.com> wrote in message
news:1136C43A-B9C2-47A8...@microsoft.com...


I don't think the Activate event fires for PopUp forms. I don't see
anything in the Access 2003 help file that explicitly says that, but it does
say that the Deactivate event doesn't fire for PopUp forms.

Klatuu has already explained about the form's GotFocus/LostFocus events.

--
Dirk Goldgar, MS Access MVP
www.datagnostics.com

(please reply to the newsgroup)

Linq Adams via AccessMonster.com

unread,
Dec 12, 2007, 12:28:02 AM12/12/07
to
Experimentation shows that (in ACC2003) Dirk is correct! Also note, from Help:


"Note The Activate event doesn't occur when a form receives focus back from
a dialog box, popup, or another form"

so it only makes sense that it doesn't work the other way either.

--
There's ALWAYS more than one way to skin a cat!

Answers/posts based on Access 2000/2003

Message posted via AccessMonster.com
http://www.accessmonster.com/Uwe/Forums.aspx/access-forms/200712/1

0 new messages