This event occurs when a Form object becomes the active window.
Private Sub form_Activate( )
A form becomes active when you use the Show or SetFocus methods in code or when a user initiates an action, such as choosing an object.
The Activate event occurs only when an object is visible, and only when the focus shifts within a single application. Shifting focus from one application to another application does not initiate the event.
The Activate event occurs before the GotFocus event.