OnActivate event not firing

G

Guest

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
 
M

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top