Linking two subform horizonal scrolling ability

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

My problem is that I have two subforms on one main form and i want to compare
the data on the two subforms. The fields are the same for both forms. the
data for one of the form has actual cost and the data for the other form has
forecast cost. When i view the data on one of the subform, in this case lets
say actual cost, i want to compare and follow along with the data on the
forecast cost subform. Basically i want to link the horizontal scrolling so
that if i scroll on the actual cost subform, the forecasat cost subform will
also scroll along. Can someone please help? thanks!!!
 
You need to find a way to put all your data in one subform. If the fields
are the same for both forms, you can create a union query that includes the
recordsources of both subforms. That gets all your data into one query and
you can then use one subform to display all the data.
 
You could look at http://www.lebans.com/setgetsb.htm which should (where
'should' means 'I haven't tried it') allow you to read the position of the
scrollbar from one and apply it to the other but, in practical terms, I'd
agree with PC that joining the two sets of data together and then viewing in
a single subform is going to be a great deal easier.
 
Back
Top