Synchronised scrolling of subforms on tab control in Access 2007
Posted on 2012-08-26
I had a continuous form in Access 2007 which had too many fields to be displayed within the 55cm limit so I thought that I would make a tab control with fourteen tabs.
Each tab has a continuous subform with 5 or 6 fields in it.
The first field of each subform is WTD_Test_Date.
All subforms get their data from the same query so they all have the same list of WTD_Test_Date.
I would like to be able to either scroll one subform and when I click on other tabs have them already at the same position as the one I scrolled on or ...
preferrably, be able to click on a WTD_Test_Date and when I look at other tabs have them already focussed on the same record.
I have seen this done if the subforms are on the main form rather than a tab control :
Me.Parent.subFrm2.Form.Recordset.FindFirst ("WTD_Test_Date = " & Me.WTD_Test_Date)
but am at a loss as to adapting this to the tab control.
Thanks for any suggestions,