Multiple sub forms

  • Thread starter Thread starter rascal
  • Start date Start date
R

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
 
rascal said:
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
Click to expand...

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.
 
Back
Top