Hardly the Subform Guru

kevinhughes2 · 2018-04-16T15:22:21.000Z

There’s got to be setting for this, but I don’t generally work with subforms so I’m clueless on this one.

The main form basically has Navigation stuff in it. Subform is where all the action is, so I want to just blow away all the tab stops in the main form so when this form opens it just shoots straight into the subform for data entry - If I need to navigate it’s just a click away, and it’s primarily a data entry form so let’s just open there and get to work.

The trouble is when I do that, the Subform opens just fine, but none of the main form controls are visible because the subform goes straight to the top of the window. Same thing if I leave one Tab Stop enabled and hit Tab key. Can I click the box in the subform? … Sure, but that’s not what automation and idiot proofing is all about.

So, how does one freeze the screen position of the main form regardless of what else is happening?

Senor Google is no help on this one - I didn’t hit the right combination of words, I guess

homer-t-nacho-cheese · 2018-04-16T15:46:24.000Z

Is it possible that your overall main form is larger than the display screen it is shown on?

When you hop into the subform, Access wants to display the entire subform. If that means scrolling down in the main form, then it will do that.

As far as getting to the control on the subform, you may need some code in your On Open section. Then again, I usually code my stuff and you can probably get away with no code to do it.

kevinhughes2 · 2018-04-16T16:39:53.000Z

No, Main form fits. If I click into the first field in the subform nothing moves and the main form stays put.

Tabbing into the Subform it goes to the correct field … If it didn’t I’d do a SetFocus in the Subform’s GotFocus (I hablo VBA )There are two fields in the subform with default value settings that pull from the main form, but I moved them to the end of the tab order and disabled their tab stops.

Subform layout is single-line, continuous because I want to see all of the records that meet the criteria, with a large enough footprint in the main form to allow the maximum number of entries I will get … but Tab is behaving differently than click which has me wondering.

kevinhughes2 · 2018-04-16T16:50:06.000Z

Also worth noting that 99+% of the time, when going into the subform there are 0 records to display, so overflow is not responsible. I did disable the scroll bars … may try turning them back on next.

kevinhughes2 · 2018-04-16T17:06:35.000Z

OK, this just got weirder (or closer to a solution maybe) … Going back into screen with data already present, it stays put just fine.

Will have to wait for another application to come in to see if it was something I changed that needed a restart of access to fix or if it’s just limited to initial data entry.

kevinhughes2 · 2018-04-27T21:10:35.000Z

It was kind of odd … expanded the subform control, still no joy.

Even though there was no fit issue, expanded the main form window and expanded the subform window again, and now it’s behaving.

homer-t-nacho-cheese · 2018-04-30T14:07:50.000Z

Did you ever figure out root cause? If not, do you need to figure out the root cause?

kevinhughes2 · 2018-04-30T15:29:36.000Z

Must have posted it when SW was having its hissy fit and got lost in the intorwebz.

Expanded the child object, no joy. Then expanded the main form (and the child again) and it is behaving now.

I’ll write it off as lack of subform experience, never had to expand a form to fill the screen before.