Syncronizing two sub-forms

[puforee]

Currently I have a form that shows First and last names in the left 2 columns. The rest of the form goes to the right about 30 fields...causing my users to scroll. When the scroll, of course, the names go out of view. I saw a web blog the other day that suggested breaking the form into two sub forms. The first sub-form would be the 2 name fields. The second sub form would contain the rest of the data. I will have a field in each sub form with common data..like a employee work number..so the link could be established.

I would like both these forms to be vertical Continuous forms. Scrolling up and down with the 1st and left to right with the second.

So, how do I synchronized the 2nd form so if follows the first. The name fields is the first have to line up with the data fields in the second. Also, when I scroll up or down with the name fields, I would want the second form to scroll also.


Any Questions or Thoughts.

 

[dhookom]

I would simply add the name fields into a single continuous form multiple times.

Duane
Hook'D on Access
MS Access MVP

 

[puforee]

dhookom
That is already what I have. The problem is, the names are in the left two fields and when the user scrolls right to see the rest of the data...the names are out of sight. I need this form to show as a Tabular form.

 

[dhookom]

How many copies of the two fields do you have in your form?

Duane
Hook'D on Access
MS Access MVP