I have an Access form whose purpose is to import data changes into a table.
Data changes are stored in a table called MemberEdits, which basically has the same columns as my Members table. MemberEdits is populated by importing data from an Excel worksheet containing those changes.
My main form has 2 subforms called MemberEditsSubform and MembersSubform. Both are continuous forms (not datasheet), and are identical to each other. Both forms contain too many fields to display, so they both have horizontal scrollbars.
When the user scrolls either of these subforms horizontally, I want the other subform to scroll to the same position.
I'm familiar with using the Windows API's, and I *think* I can use GetScrollInfo and SetScrollInfo API's.
I've seen an example of GetScrollInfo which returns a scroll position, but this was for a ListBox, and used its Scroll event to trigger the code.
I don't believe a form or subform has a Scroll event, so I don't know how to trigger the code I need. Would SendMessage help, knowing the hWnd of the form?
Thanks...