Tabbing into subform collapses main form.

[njdaisy86]

I'm currently a beginner/intermediate Access databaser without SQL proficiency. Currently, I have a 1 to many database. Table 1 (main) - Employee info. Table 2 - Transfer info. I set up a form (employee info main form) with a sub-form (transfer info).

My frustration is, when I tab into my sub-form (continuous form) from the main form, my main form collapses. :banghead: If I use the mouse to click in a tab in the subform, the main form does not collapse.

 

[MarkK]

Hello and welcome...

What does it mean that the main form collapses? This does not form a picture in my mind of things I am aware of that main forms can do. What does a collapse look like, or how do you know it occurs?
Curious,
Mark

 

[njdaisy86]

When I open the form, the main form with 5 fields are displayed on top. When I tab to the subform below, that entire subform moves up and hides the main form. when I try to expand the main form my clicking on it, nothing happens. I can only see the subform (and it's fields) and the main form heading. it's so strange.

 

[MarkK]

Is the subform too big for the screen? Does the mainform move up on-screen in order to show all of the subform? Try, in design view, make sure the subform is small enough to fit on screen. Also, make sure the extents of the mainform do not exceed the screen size.
Mark

 

[arnelgp]

1. adjust the height of your subform
to just a very small (only a line
of fields is shown).

2. pull your Main form's
Form Footer (if you have one)
to touch the bottom part of
your subform.

3. set your Subform's Vertical
Anchor to Both

(optional, you may also
adjust your subform's
Horizontal Anchor to Both
if you want to resize the
subform's right margin)

 

[njdaisy86]

okay, so this is why you guys are the geniuses! Thank you ever so much! problem solved, as you indicated my sub-form was ridiculously too large for what I needed. you can't imagine how long I spent researching that stupid (on my part) issue. And I also learned about anchoring. Thank you thank you!