Access97 Form

[vr]

I have a tab control form with 5 tabs.<br>
<br>
Tab 1-3 datasource = main table<br>
Tab 4-5 datasource = second table<br>
<br>
I need to know how/where to write code for the following:<br>
<br>
If field 4 on main table = &quot;01&quot; and tab 4 is clicked, automatically open tab 5 instead of 4. <br>
<br>
Can anyone help?<br>
<br>

 

[elizabeth]

Slightly different approach, you can write code in the form's OnOpen event and Field4's OnUpdate event to control whether tab 4 or tab5 is visible (tabFour.Visible=Yes). Less confusing for the user.