one scroll bar to navigate in both form?

[KrisN]

I have two forms. First form allows data entry while the second form shows
formulated data for each data row. I currently have the Master/child linked
up correctly but some records have more then what can fit on a form. When I
scroll in the main form the other form is stagnant.Since I need the forms to
be continuos, I could not do a subform. Is there a way to make the first
scroll bar navigate in sync with the second form and have only one scroll bar
navigate/control both form simultaneously by writing a vba code?.

 

[Graham Mandeno]

Hi Kris

You cannot have a single scrollbar that will scroll two forms, but you can
synchronise scrollbars using code.

Stephen Lebans has some code for manipulating scrollbars on his website
here: http://www.lebans.com/setgetsb.htm

 

[KrisN]

Hi Graham,

How would I go about tranfering or applying Leban's example? Please provide
step by step instruction if possible. How do I go about synchronizing both
form to scroll at the same time and is the code written as a generic code or
will I need to change/modify the code provided by Leban's example?

Kris

Hi Kris

You cannot have a single scrollbar that will scroll two forms, but you can
synchronise scrollbars using code.

Stephen Lebans has some code for manipulating scrollbars on his website
here: http://www.lebans.com/setgetsb.htm
--
Good Luck

Graham Mandeno [Access MVP]
Auckland, New Zealand

I have two forms. First form allows data entry while the second form shows
formulated data for each data row. I currently have the Master/child
linked
up correctly but some records have more then what can fit on a form. When
I
scroll in the main form the other form is stagnant.Since I need the forms
to
be continuos, I could not do a subform. Is there a way to make the first
scroll bar navigate in sync with the second form and have only one scroll
bar
navigate/control both form simultaneously by writing a vba code?.