OnActivate event not firing

[David Mueller]

I have a subform on a tab control that just won't fire the OnActivate event.
I haven't found anything that says this is normal.

I placed a line of code in the OnActivate event, upon which I have placed a
breakpoint. I also included a debug.print line and error trapping just in
case.

I click the tab, click text box controls on the subform, click around,
change values, click another tab, go back, ... nothing fires this event.

Private Sub Form_Activate()
On Error GoTo Err_Activate

Call Highlight_Estimated_Data(Me)
Debug.Print "sfrm_pgSpouse :: On Activate"

Exit_Sub:
Exit Sub

Err_Activate:
MsgBox "Err on activate: " & Err.Description
GoTo Exit_Sub
End Sub

 

[Michel Walsh]

Hi,


It is probably not considered an "active window", even if it is a window.


You can always call the specific subform procedure, after you made it
public, from the activate event of the main form?


Hoping it may help,
Vanderghast, Access MVP