By A.D. Tejpal
This sample db demonstrates synchronized scrolling of two subforms (both in datasheet view).
Two modes are covered:
(a) One way synchronization: Top subform always functions as the master while the other one serves as the slave.
(b) Two way synchronization: Whichever subform happens to be the active one, functions as the master while the other one serves as the slave.
Note: For ready identification, the subform currently serving as the slave, has a darker back color as compared to the master.
For each of the above modes, three alternative styles of scroll synchronization are demonstrated:
(a) Synchronize horizontal scroll only.
(b) Synchronize vertical scroll only.
(c) Synchronize both horizontal and vertical scroll.
Sample data depicts student's scores in phase 1 (top subform) and phase 2 (bottom subform). For each student, wherever the scores in these two subform happen to differ, the same get highlighted as follows:
(a) Top subform: Light grey.
(b) Bottom subform: If value is greater than that in other subform, it gets highlighted in light green. On the other hand, if value is less than that in other subform, it gets highlighted in light pink.
Note: The above highlights get suitably updated promptly on editing of data in either of the two subforms.
Version: Access 2000 File Format
You can find the sample here: