Multiple sub forms

[rascal]

I have a main form that has 3 subforms all linked by date. What I would like
to do is when the data has been entered into 1 subform and I go to the next,
have the 1st subform shrink, and the same for the 3rd subform. Is this
possible? I am using access 2007

 

[Arvin Meyer [MVP]]

I have a main form that has 3 subforms all linked by date. What I would like
to do is when the data has been entered into 1 subform and I go to the next,
have the 1st subform shrink, and the same for the 3rd subform. Is this
possible? I am using access 2007

A subform is really a control, not a form, so just use the current event
of the next subform to change the control height of the previous one,
something like (air code):

Private Sub Form_Current()
Me.NameOfControlToResize.Height = 360
End Sub

Form measurements are in Twips. There are 1440 Twips to the inch, so 360
Twips is a 1/4 of an inch.