Sub Forms
- Thread starter k209310
- Start date
- Local time
- Today, 16:12
- Joined
- Feb 28, 2001
- Messages
- 30,554
Yes, though it requires you to be a bit careful.
Build your subforms individually. In form design mode, make the form REALLY long. Insert each subform separately. Then, when you have it working right, you will move the subforms so that their upper left corners overlap. After that, you can shrink the form to its minimum size that will hold everything.
Put info in your combo box that identifies the data you wish to see. Make the combo box UNBOUND with respect to any table. Now add event code to the box's AfterUpdate event that loops through all of the possible sub-forms. How you define this is up to you. But inside this loop, if the information in the combo box does not match the info associated subform then make that form invisible. (subform.visible = False). For the one you wanted to see, make it visible.
Now, how you go about associating the combo-box options with the subforms is your call.
Personally, I would do this another way. Build a tab-control form with one tab-page for each subform plus perhaps a blank page just for aesthetics. Put a single subform, always visible, on each page of the tab control. Then just let the user select the tab. Or if you MUST use the drop-down, have the AfterUpdate event select the tab for you.
Build your subforms individually. In form design mode, make the form REALLY long. Insert each subform separately. Then, when you have it working right, you will move the subforms so that their upper left corners overlap. After that, you can shrink the form to its minimum size that will hold everything.
Put info in your combo box that identifies the data you wish to see. Make the combo box UNBOUND with respect to any table. Now add event code to the box's AfterUpdate event that loops through all of the possible sub-forms. How you define this is up to you. But inside this loop, if the information in the combo box does not match the info associated subform then make that form invisible. (subform.visible = False). For the one you wanted to see, make it visible.
Now, how you go about associating the combo-box options with the subforms is your call.
Personally, I would do this another way. Build a tab-control form with one tab-page for each subform plus perhaps a blank page just for aesthetics. Put a single subform, always visible, on each page of the tab control. Then just let the user select the tab. Or if you MUST use the drop-down, have the AfterUpdate event select the tab for you.
Similar threads
