Continuous Form Scroll Lock

[Rickety107]

I have a form with a continuous subform. The issue I have is that the user
is inputting data into the continuous subform. The amount of data that needs
to be displayed results in a horizontal scroll bar. When the user scrolls to
the right they can no longer see the information in the first 3 fields on the
left. Is there a way to freeze the left 3 fields so that when the user
scrolls to the right they will stay visible?

 

[OldPro]

I have a form with a continuous subform. The issue I have is that the user
is inputting data into the continuous subform. The amount of data that needs
to be displayed results in a horizontal scroll bar. When the user scrolls to
the right they can no longer see the information in the first 3 fields on the
left. Is there a way to freeze the left 3 fields so that when the user
scrolls to the right they will stay visible?

There is no easy way. You could create two subforms, one with only
the first three fields and the other with the remaining fields and
figure out a way to keep them in sync as the user scrolls through
them. Another solution may be to put fields on the form below the
subform that show those three fields in the current record. Either
one is problematic and may not work out. If it was me, I would not
use a continuous form for data input; double-clicking on a record
would popup an edit screen that is manually populated and saved with a
Save button. An append button on the main form would bring up the
same edit screen with blank fields and use .Addnew instead of .Edit in
the Save code.