Tab Controls on Sub Form

ted.martin

Registered User.
Local time
Today, 13:34
Joined
Sep 24, 2004
Messages
743
I have a main form called F-Clients
On this form there is a tab control tabClients
On this tab control (tabClients), on tab 2 Shoot, there is a subform SF-Shoot
On this subform SF-Shoot, is another tab control TabShoot.
On this tab control (TabShoot) , tab 3 is Invoicing


I need to open the form F-Clients at the TabShoot Tab3 Invoicing tab

Code:
 TabClients.Value = TabClients.Pages("Shoot").PageIndex

This gets me so far but how do I then refer to the SF-Shoot tab3 (invoicing) on the sub form SF-Shoot?

Thanks
 
Thanks - got it

Code:
     TabClients.Value = TabClients.Pages("Shoot").PageIndex
'    [Forms]![F-Clients].[SF-Shoot].Form.TabShoot.Value = 3
    [Forms]![F-Clients].[SF-Shoot].Form.TabShoot.Value = [Forms]![F-Clients].[SF-Shoot].Form.TabShoot.Pages("Invoicing").PageIndex
 

Users who are viewing this thread

Back
Top Bottom