Scroll bar for form in sub-container

[pgruenke]

I have a main form that contains three tabs, each of which controls a form appearing in the sub-container. I dropped a page break onto the first sub-container form so that I could have a scroll bar available (form is 17" long). Works perfectly as long as I am just entering data. But if I omit a required piece of data the pop up appears telling me I must enter the data. When I close the pop up and enter the data, I loose all control of the sub-container form, which automatically jumps to the top of the sub-form. This becomes a major pain especially if more than one required data is omitted. How can I retain control of the form?

[isladogs]

For any other control, you could check if DCount=0 & if so, disable the control
Unfortunately the page break control is unique in that it can't be hidden or disabled

So I think you need to do one of the following:
a) devise some other method of forcing a scroll bar
b) check for the required data item and enter it automatically if feasible thus preventing the popup
c) remove the required status for that field
d) redesign your form layout to break in a different way

I suspect you will say none of those are a satisfactory outcome
Without seeing your report its difficult to come up with a solution you are likely to be happy with

[pgruenke]

Colin, I would be ecstatic with your "a". Is there another way to force a scroll bar when the form is in a sub-container? "b" and "c" aren't possible. Its a form, not a report, and the only reason I have the page break is to force the scroll bar.

[isladogs]

I meant form - no idea why I wrote report - I've corrected it now
As you realise, scroll bars only appear when a control has focus
Can you add code to reset the focus back to the 'sub-container' after entering the data?
Assuming the focus is in the form (or subform) containing your 'sub-container'

Me.SubFormName.SetFocus

or if it's a textbox in the subform

Me.SubFormName.Form.TextboxName.SetFocus

If its in another subform, then you'll need more complex code .
Something like:

Parent.SubFormName.Form.TextboxName.SetFocus

See this link for more info http://allenbrowne.com/casu-04.html

Also this thread may have something useful - similar idea in some ways:
https://www.access-programmers.co.uk...+without+focus

Good luck
I'm signing out now.