Form_SynchronizedSubforms Updated On: 29-Nov-2011 (Tweaked to suit Access 2010 as well) Explanatory Notes
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
Reference: Nothing Extra
Note: This sample db makes use of certain functions in module modGet-SetScrollInfo contained in Stephen Leban's sample db named SetGetScrollbars.
Download File >>: http://www.rogersaccesslibrary.com/forum/uploads/37/Form_SynchronizedSubforms.zip -
|