Tab Control Code Doesn't Run on Page Click Event

[Evan Camilleri]

Tab Control Code Doesn't Run Page Click Events: why and what is the work
around?

Evan Camilleri

 

[Allen Browne]

Use the Change event of the tab control.

That's the event that runs when a different tab is clicked.

 

[Guest]

The tab is a seprate object from the detail section. You will need to
provide code for both click events in order to achieve your desired result.

You can write a single function to be called by each event.

Example:

Sub DoMyCommand()
'Place procedures here
End Sub

Sub Page1_Click()
DoMyCommand
End Sub

Sub Detail_Click()
DoMyCommand
End Sub

Hope this helps. Good luck.

 

[Evan Camilleri]

Thanks, that's the way

Use the Change event of the tab control.

That's the event that runs when a different tab is clicked.