Two issues - scrolling and tabbing

[RenaG]

I have a form that also contains a subform. The main form takes up about 1/4 - 1/3 of the window. The subform is a continuous form and takes up the remainder of the window plus continues past the bottom of the window. I have two vertical scroll bars - one for each window.

First, as we enter data into the subform and it grows, the new fields go below the window; it doesn't scroll up so that we can see the fields. I have to manually pull down the scroll bar of the main form and the subform to see the new fields. Is there a way around this?

Secondly, when we finish entering the data and want to start a new record, we click the right arrow next to the outer Record (associated with the main form) and the cursor lands on the first record of the subform. I would like for it to go to the first field in the main form. I have tried to SetFocus on the field in both the Form_Open and Form_Load events with the:

Me.sDate.SetFocus
​

statement and that doesn't work. Am I putting it in the wrong place? Is it the wrong command? Or is this just something I am going to have to live with?

TIA!

 

[RenaG]

Correction on the scrolling issue:

I found that if I just pull down the vertical scroll bar on the main form so that I can see the bottom of the subform window, the subform window does automatically scroll up as I enter the data. So I guess that is probably working like it should unless somebody has a trick that would enable me to not to have to manually scroll the main form window.

 

[boblarson]

You just have your form larger than the available space on your monitor for the main form. If you resize things so that you don't have to scroll, then it will be fine. Can you post a screenshot of the mainform in both form view and in design view? See here for how to post screenshots on the forum.

 

[RenaG]

Hey Bob,

I tried to follow your instructions for uploading an image but when I just did the Copy Shortcut and then a paste here, I got the following:

http://www.access-programmers.co.uk/forums/attachment.php?attachmentid=36668&stc=1&d=1302034727

http://www.access-programmers.co.uk/forums/attachment.php?attachmentid=36667&stc=1&d=1302033670

But when I clicked the Insert Image icon on the toolbar, it actually pasted the image itself. Hope this is what you were saying to do.

Anyway, I looked at the form to see how I would resize it and I don't see how that is done. The Form Footer goes on forever. In the Property sheet I see an Auto Resize option and a Fit to Screen (both set to yes on both the main form and the subform).

 

[boblarson]

Well, what would help is to make the main form header smaller, squeeze the main form fields a little more together in their vertical spacing, make the comments text box just a little smaller, perhaps just collapse the Ribbon when using the program unless necessary (Ctrl + F1 should do that). And, maximize the Access Application.

 

[RenaG]

Great suggestions!! I did all the above: tightened up the header of the main form, collapsed the ribbon and maximized the window. It works really well now. The subform scrolls up as I fill up the screen. And an added bonus, it doesn't show the Records bar on the subform which will reduce the confusion for the data entry clerk.

Did you have any suggestions for my tabbing question:
When I have completed the form and want to advance to a new form, I click the right arrow on the Records bar. My cursor lands on the first field of the subform instead of the first field of the main form. Is there a way to fix that?