I am using the code (see below for a partial listing) from Stephen Lebans that I have modified to synch the horizontal scrollbar movement of two datasheets. However, I need to skip this process when the vertical scrollbar is used to view records--as this interrupts the conditional formatting I am using on the second datasheet.
'*************************************************
Private Sub Form_Timer() 'Access 2002-2003
'*************************************************
On Error Resume Next
'If scrollbar = horizontal then
If myCTL = "frm1" Then
Me.txtPos=fSetScrollBarPosHZ(frm1,fGetScrollBarPosHZ(frm2))
Else
Me.txtPos=fSetScrollBarPosHZ(frm2,fGetScrollBarPosHZ(frm1))
End If
'End If
End Sub
(This is not the exact code, but close enough--as I have reduced the syntax to fit this screen.)
I appreciate your help. Thanks!
David