I want to capture from one form, frm_HeaderComplex, the horizontal scroll event when I scroll the form (datasheet style) left or right. When that happens I want another form, frm_Data, to scroll the same direction and the same amount, i.e. sychronise the horizontal scoll on 2nd form to the 1st form .
I see in Access Help there is a Scroll Event:
Private Sub object_Scroll( )
Private Sub object_Scroll( ActionX As fmScrollAction, ActionY As fmScrollAction, ByVal RequestDx As Single, ByVal RequestDy As Single, ByVal ActualDx As MSForms.ReturnSingle, ByVal ActualDy As MSForms.ReturnSingle)
But I can not seem to make either work
Using Access 2007. both forms are datasheet view.