synchronizing horizontal bars on two subforms (1 Viewer)

hllary

Registered User.
Local time
Today, 16:14
Joined
Sep 23, 2019
Messages
80
I have a form that has two subforms that are in data sheet view. is there a way to synchronize the horizontal bars on both subforms?

So when the user scroll to the right both Subform1 and Subform2 stay insync.
 

bastanu

AWF VIP
Local time
Today, 16:14
Joined
Apr 13, 2010
Messages
1,401
This is what I do (both subforms have the same number of fields and I use the same naming convention):
Code:
Private Sub Field1_Enter()
On Error Resume Next
Me.Parent.Form.sfrmlBCS_Profiles_Import.Form.Controls("Field1").SetFocus
Me.Field1.SetFocus
End Sub

So I have similar code for all controls in the subforms (you could also create a macro and use that in the OnEnter events to make it easier to implement).

Cheers,
Vlad
 

Users who are viewing this thread

Top Bottom