Linking tab controls 1

[DoctorJDM]

Hi

Have a quote/job process where a quote is built up in one form with a QuoteRef. If accepted a status field is changed to Job and a JobRef is allocated. The tables behind the Quote build up data on usage of Timber, Components and Hours, and contain both quoted and actual values in each case.

The same tables then feed the Jobs form, which has subforms for actual usage of Timber, Components and Hours on tab controls. Because of space limitations the subforms have to be in Single Form view.

It would be much neater to have two sets of synchronised tab controls showing the separate Job and Quote qhantities in Datasheet view, ie clicking on the 'Job Timber' tab in the Job set automatically opens the 'Quote Timber' tab in the Quote set below it, and so on for the other tabs.

Is this possible?

 

[Remou]

Assuming that the pages correspond (1 - 1, 2 - 2):

Private Sub tabJob_Change()
   Me.tabQuote = Me.tabJob
End Sub

 

[DoctorJDM]

Remou

That's great, thanks!

Had to explore a bit to understand so for anyone else's benefit

- in Design View click the edge of the first tab control and open Properties; it will have a name like TabCtl123; I renamed it to JobSubforms

- renamed the second tab control to QuoteSubforms

- back in the first one's properties there's an On Change event, which now says me.QuoteSubforms=me.JobSubforms

The second set of tabs now dutifully follows any changes in the first set.