subform behavior in access 2003

[mdugan2453]

I am trying to see if the behavior I am seeing with an access continuous
subform is normal, and if I can change it.

When I enter the first record of data into the subform, and tab out of the
last field, the subfrom scrolls the record I just created off-screen, so that
only a new empty record is showing. When I fill this out, and then tab out
of last field, it does the same thing: records keep getting pushed out of
site and leave just the empty new record in view. Is this normal? In an
access 97 app I have, the records fill the whole subform, and then start
scrolling up from the bottom: you always see a full set of data, with the new
empty record at the end, not alone at the top.

thanks for any and all help!
mike

 

[Linq Adams via AccessMonster.com]

Without having your app in front of me, I'm just guessing here, at least in
part.

Filling in the last field then tabbing is taking you to a new record. This is
because the Cycle Property is set to its Default of "All Records." Go to the
form's Properties - Other and change it to "Current Record."

The guessing part is that maybe the subform control is too small to display
more than one record at a time. This can be because of the control being
sized too small, but more often is because you have too much dead space under
the last line of controls. In Design View make sure that the bottom of the
form is snugged up against the bottom-most row of textboxes,

 

[RoyVidar]

I am trying to see if the behavior I am seeing with an access
continuous subform is normal, and if I can change it.

When I enter the first record of data into the subform, and tab out
of the last field, the subfrom scrolls the record I just created
off-screen, so that only a new empty record is showing. When I fill
this out, and then tab out of last field, it does the same thing:
records keep getting pushed out of site and leave just the empty new
record in view. Is this normal? In an access 97 app I have, the
records fill the whole subform, and then start scrolling up from the
bottom: you always see a full set of data, with the new empty record
at the end, not alone at the top.

thanks for any and all help!
mike

Is your Default View set to Single Form vs Continuous Form (The
subforms properties, Format tab)?