If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
Multiple sub forms
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 |
#2
|
|||
|
|||
Multiple sub forms
rascal wrote:
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. -- Arvin Meyer, MVP, MCP Microsoft Access |
Thread Tools | |
Display Modes | |
|
|