How to freeze parts of form?

[Abacus1234]

I have a subform in the Form Header, and the Main form in the detail.

When I scroll, the main form goes behind the subform. I would like it to stay positioned and not to slide behind the subform. Can this be done? Thanks for any help.

[ItsMe]

Maybe you can place everything in the Detail Section.

[ssanfu]

I just added a subform to the form footer, then moved the subform to the form header. I cannot replicate what you described. Are you sure the sub form is in the subform control in the form header?

Could you post your dB??

[ItsMe]

I just added a subform to the form footer, then moved the subform to the form header. I cannot replicate what you described. Are you sure the sub form is in the subform control in the form header?

Could you post your dB??

That makes sense. Maybe we are discussing a split form?

[ssanfu]

@ItsMe,
Had not even thought about a split form. I never use them, so I don't know anything about them.


EDIT: Just created a split form (my first!). Nothing floating about anything. I can make the form covered by the datasheet, but I have to use the splitter bar - doesn't happen automatically. Tried top, bottom, left and right. could not replicate the problem.

[Abacus1234]

I suppose that some things got to give, as the length of the form is longer than the screen. I would just really like the option of seeing all the main form on the screen. I will experiment with your suggestion. I just can't visualize it before I do it. Thanks.

[Abacus1234]

Yes, I'm pretty sure the subform is in the subform control. What I am calling the main form, is the form without the subform and it is longer than the screen, so it has to go somewhere when I scroll down. I'm trying to visualize what it would look like it if actually went in front of the subform, (if it were even possible). Does anyone know how a split screen would be different. Presumably I would have 2 ?frozen screens? so I would still have the problem. I'm beginning to think it has to work this way. Thanks for all the input.

[ssanfu]

Ahhhh, got it. Even if you put the sub form in the form footer, the main form detail section will scroll behind the form header/footer if the detail section is too long.

The only way I know of to stop the hiding of controls is to use the tabs control and group control on different tabs until the main form detail section is short enough.


Another thought is that if you have that many fields on the main form detail section, maybe you need to look at normalizing your table structures.

[Abacus1234]

I have another form which prints out on legal size paper, so I think your idea of putting it all in the detail may work. Yes putting all in the detail works for me. While the user is doing data entry they can scroll up and down and see the subform and the main form in its entirety. Thanks again for all inputs. It's a better solution that where I started.

[ItsMe]

Glad to hear you have found a solution. I will add that, when using forms, it is best practice to get all of the controls and information into the space provided by the User's screen. So, you would want to eliminate any chance the user would have to use a scroll bar. Of course, this is not always practical. There are many obstacles, like different size monitors, etc. However, I try to avoid the use of scroll bars and limit them only to Datasheet View or Continuous View of forms. If I find myself needing more real estate, I will consider using another form or maybe a Tab Control. I will also limit the use of Datasheet and Continuous View to subforms or Pop-Up forms.