Which Event should I use?

[gizzu]

Form1 has a sub form, Form2, which have a tab control with a number of tabs. One of them, Tab4, includes a sub form, Form3.

I have an SQL statement that I want to run (using DoCmd.RunSQL) when Form3 is shown on screen the first time, e.g. when Tab4 activates. I've tried OnClick for Tab4, OnActivate for both Form3 and Tab4 along with a dozen other events with no result. Maybe the problem is that the tab control is also in a subform?

Any suggestions?

 

[MarkK]

Use the Change Event of the tab control and check its Value property to determine the current page.

 

[gizzu]

Thank you!

This worked perfectly! Thanx alot!