Tab Navigation

[FREDDY67]

Afternoon

I may be going about this in a backward manner but this is where I am at, I have a text box on a sub form in tab 1 which updates a hidden text box on the main form which in turn updates records in another sub form in tab 2. Is it possible to add an afterupdate event procedure to the hidden text box on main form to open tab 2?

I have searched but haven't found answer, any help appreciated.

Thanks

Freddy

 

[RuralGuy]

The AfterUpdate event *only* fires when the user makes a change, not code.

 

[FREDDY67]

Thanks for the info, is there another way of navigating from tab 1 to tab 2 automatically & not using the tabs at the top?


Thanks

Freddy

 

[RuralGuy]

The TabIndex is the default property of the Tab Control and simply executing Me.TabCtlName = 1 will switch to the 2nd tab (it is 0 based). You can also set the focus to a control in the 2nd page and the Tab will switch.

 

[FREDDY67]

Rural Guy

Many thanks for your help but I am still struggling (thick),I have uploaded a trimmed down copy of my db. On the form declarations I want to be able to select a record & navigate to the 2nd tab (called Form),if you could have a look sometime it would be appreciated.

Thanks

Freddy

View attachment Subform Navigation.zip

 

[RuralGuy]

Where you are making your selection you need to add some code.

Private Sub Command17_Click()
   Me.Selection = [Horse]
   [COLOR="Red"][B]Forms!Declarations.TabCtl2 = 1[/B][/COLOR]
End Sub

 

[FREDDY67]

Rural Guy

Many thanks for your help & perseverance, your code works perfectly.

Freddy